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 vote344 views1 answer
Change date in pivot table to month in sql server
SQL
15 votes289 views2 answers
How to drop database name in postgresql
SQL
0 vote297 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
5 votes327 views1 answer
Sql add column after another
SQL
1 vote294 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote348 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
-1 vote315 views1 answer
Spring boot mysql connection properties
SQL
7 votes333 views2 answers
MySQL IF without else
SQL
0 vote300 views1 answer
Postgresql heritage
SQL
1 vote333 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL