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 votes104 views1 answer
APEX elapsed time
SQL
0 vote154 views1 answer
Drop a view in sqlite
SQL
1 vote106 views3 answers
Sql server get week dates from week number
SQL
0 vote103 views2 answers
Oracle create tablespace autoextend
SQL
2 votes148 views1 answer
Username sql
SQL
4 votes114 views2 answers
Tables in sql
SQL
17 votes136 views6 answers
Sql current date
SQL
0 vote114 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote129 views1 answer
Calculer pourcentage mysql
SQL
1 vote111 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL