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

5 votes191 views1 answer
Sql add column after another
SQL
6 votes194 views5 answers
Mysql get last insert id
SQL
0 vote226 views1 answer
Postgres get database encoding
SQL
0 vote201 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
1 vote191 views1 answer
Mysql current time
SQL
0 vote192 views1 answer
How to add boolean column in postgresql
SQL
1 vote203 views1 answer
Query for all indexes in table postgres
SQL
0 vote194 views1 answer
Postgres declare variable
SQL
1 vote206 views1 answer
Psql show with user is logged in
SQL
0 vote187 views1 answer
Sql server select furst day of current year
SQL