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 vote180 views3 answers
Java.sql.sqlexception: access denied for user
SQL
24 votes171 views6 answers
Replace mysql
SQL
0 vote167 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote184 views1 answer
SQL Server date literal
SQL
1 vote176 views1 answer
Mysql show queries running
SQL
0 vote174 views1 answer
Mysql case when null
SQL
4 votes183 views4 answers
Pl sql output
SQL
9 votes183 views5 answers
Laravel to sql
SQL
0 vote170 views1 answer
Tsql generate rows
SQL
0 vote176 views1 answer
Set a value by excuting stored procedure
SQL