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

3 votes167 views3 answers
Start postgresql ubuntu
SQL
7 votes139 views4 answers
What is my mysql version
SQL
0 vote144 views1 answer
Flush user resource mysql
SQL
0 vote138 views1 answer
How to find username and password in oracle 18c
SQL
0 vote133 views1 answer
View acl table oracle
SQL
3 votes131 views2 answers
Pl sql escape '
SQL
2 votes133 views2 answers
Compare date mysql
SQL
0 vote150 views3 answers
Database restoring error
SQL
0 vote143 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
12 votes222 views4 answers
How to drop all tables in postgresql
SQL