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

23 votes113 views6 answers
How to create table in sql
SQL
0 vote113 views2 answers
2nd max salary query in sql
SQL
1 vote110 views1 answer
Mysql select utc time in eastern time
SQL
0 vote111 views2 answers
Postgresql display subquery as json
SQL
0 vote76 views1 answer
Check sql query executed wp
SQL
0 vote116 views1 answer
Mysql not defined
SQL
5 votes121 views1 answer
AND OR NOT operators sql
SQL
0 vote132 views1 answer
Count in sql and diff
SQL
8 votes115 views1 answer
Oracle search stored procedures for text
SQL
0 vote117 views1 answer
Show all mongodb
SQL