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

37 votes241 views6 answers
Mysql update
SQL
1 vote189 views1 answer
Right outer vs left outer join
SQL
0 vote198 views1 answer
OFFSET consulta mysql
SQL
-1 vote200 views1 answer
Ssms connect with connection string
SQL
0 vote191 views1 answer
Allow external access to mysql
SQL
3 votes189 views2 answers
Mysql update row
SQL
5 votes207 views1 answer
Oracle list days between two dates
SQL
0 vote154 views1 answer
Expose db in virtualbox
SQL
0 vote257 views1 answer
Sql select first and last record of each group
SQL
0 vote202 views1 answer
Mysql listing get a particu particular user firsdt
SQL