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

6 votes192 views2 answers
Psql load dump
SQL
12 votes184 views2 answers
Insert multiple rows from another table sql
SQL
150 votes533 views10 answers
Grepper
SQL
10 votes176 views1 answer
Create table oracle
SQL
16 votes189 views1 answer
CTE statement sql server
SQL
0 vote150 views1 answer
Count char in java
SQL
0 vote186 views2 answers
Sql join on wildcard
SQL
2 votes200 views2 answers
Postgresql get table names
SQL
0 vote180 views1 answer
Sql server port 1434
SQL
3 votes310 views1 answer
Ssh check mysql version
SQL