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 vote328 views1 answer
How to check even or odd in sql
SQL
0 vote335 views2 answers
Auto increment column in mysql query results
SQL
-1 vote340 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote325 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote335 views1 answer
List all functions and procedures in postgres query
SQL
1 vote334 views2 answers
How to enable error squiggles in vs code
SQL
18 votes347 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote281 views2 answers
Jupyter notebook connect to database
SQL
20 votes337 views4 answers
Sqlite create table if not exists
SQL
-1 vote352 views1 answer
Partial search in sql
SQL