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 vote229 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote243 views1 answer
Alter domain sql
SQL
0 vote216 views1 answer
Connecting mySQL to STS
SQL
3 votes240 views2 answers
Oracle drop sequence
SQL
22 votes222 views4 answers
Mysql date format
SQL
1 vote213 views2 answers
Datetrunc hour snowflake
SQL
0 vote230 views2 answers
Functions with parameters SQL
SQL
0 vote210 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote204 views1 answer
Convert sql server guid to varbinary
SQL
0 vote223 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL