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

2 votes163 views1 answer
Oracle block
SQL
0 vote120 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote131 views1 answer
Create view in sql server that contain multiple select statements
SQL
1 vote108 views1 answer
Too many connections mysql
SQL
4 votes124 views2 answers
How to insert ip address in mysql using php
SQL
0 vote121 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
1 vote302 views1 answer
Postgres upgrade to superuser
SQL
0 vote181 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
0 vote135 views1 answer
Sql last time database was accessed
SQL
-1 vote72 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL