MySQL DISTINCT

Query DISTINCT

SELECT DISTINCT Column_name FROM table_name;

MySQL DISTINCT

When querying data from a table, you may get duplicate rows. In order to remove these duplicate rows, you use the DISTINCT clause in the SELECT statement.

Here is the syntax of the DISTINCT clause:

SELECT DISTINCT
    select_list
FROM
    table_name;

Source: mysqltutorial.org

Similar codes

0 vote147 views1 answer
Sql server get date of previous sunday
SQL
0 vote169 views1 answer
How to create a new db from dumb file mysql
SQL
1 vote170 views2 answers
Mysql trim spaces
SQL
0 vote168 views1 answer
Duplix print in Smartforms
SQL
0 vote173 views1 answer
Oracle last connexion
SQL
6 votes170 views3 answers
Date_trunc postgres
SQL
2 votes175 views2 answers
Storing timezones in postgres
SQL
1 vote401 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote195 views1 answer
Continue in sql
SQL
6 votes168 views2 answers
Foreign key sqlite3 python
SQL