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

1 vote238 views1 answer
Postgresql create table with timestamp
SQL
4 votes158 views1 answer
And or sql order of operations
SQL
1 vote192 views2 answers
How to check username in mysql command line
SQL
0 vote213 views1 answer
Sqlserver now
SQL
1 vote247 views1 answer
Print year of a date sql
SQL
2 votes205 views2 answers
Select list is not in group by clause
SQL
5 votes216 views1 answer
Sysdate in oracle sql
SQL
0 vote195 views1 answer
Sql server alter table column nullable
SQL
0 vote199 views1 answer
Mysql create table columns with spaces
SQL
0 vote277 views1 answer
Insert into table with only identity column
SQL