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 vote189 views1 answer
Stored procedure function relation
SQL
0 vote195 views1 answer
Mysql date only no time
SQL
4 votes188 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
-1 vote198 views1 answer
How to dump .csv file into mysql
SQL
0 vote203 views1 answer
Laravel migration sql dump
SQL
2 votes180 views1 answer
Mysql list users on ubuntu
SQL
2 votes191 views1 answer
Mysql virtual column
SQL
0 vote220 views1 answer
Add column not null with default value postgres
SQL
0 vote217 views1 answer
Data types mysql vs postgresql
SQL
1 vote202 views1 answer
How to set up a trigger in sql
SQL