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

3 votes178 views1 answer
Sql server version query
SQL
13 votes236 views3 answers
Sql online code
SQL
1 vote265 views1 answer
Create new table from old table with data
SQL
0 vote224 views1 answer
Sql query for login with email or username
SQL
2 votes185 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote233 views1 answer
Is sql fast
SQL
0 vote196 views4 answers
What is unique key in sql
SQL
0 vote172 views1 answer
Transaction database with php
SQL
0 vote146 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
1 vote250 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL