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 vote135 views1 answer
Mysql uuid
SQL
2 votes95 views1 answer
Sql float to int
SQL
0 vote129 views1 answer
Oracle list index on table
SQL
3 votes145 views2 answers
Install mysql powershell
SQL
-1 vote129 views1 answer
Sql getdate date only
SQL
1 vote134 views1 answer
Update from select join
SQL
-3 votes127 views1 answer
Remove spaces sql 2008
SQL
0 vote138 views1 answer
My sql data file extention
SQL
1 vote220 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote134 views1 answer
How to use group_concat in sql server
SQL