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 vote313 views2 answers
Sqlite unique
SQL
3 votes438 views1 answer
How to get yesterday date in sql
SQL
5 votes328 views1 answer
Get table columns from sql
SQL
0 vote315 views1 answer
Oracle date summer time
SQL
0 vote372 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote324 views1 answer
Alter table engine mysql
SQL
11 votes306 views4 answers
Round in sql
SQL
3 votes336 views1 answer
APEX elapsed time
SQL
0 vote325 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote326 views1 answer
Postgres select from values
SQL