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

4 votes303 views4 answers
Pl sql output
SQL
0 vote287 views1 answer
Turnicate in mysql
SQL
0 vote286 views1 answer
Sql server udf performance
SQL
0 vote304 views1 answer
Mysql get only the field names in a table
SQL
25 votes291 views3 answers
Mysql command show tables
SQL
18 votes311 views3 answers
Get the list of all tables in sql server
SQL
6 votes270 views1 answer
Phpmyadmin reset root password
SQL
0 vote280 views1 answer
Mysql command prompt date insert format
SQL
0 vote345 views1 answer
Delete from IN subquery
SQL
11 votes312 views3 answers
How to get last row of table in sql
SQL