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

2 votes113 views2 answers
Mysql does sentence contain word
SQL
0 vote96 views1 answer
Postgres data location
SQL
21 votes112 views3 answers
Average sql
SQL
0 vote104 views1 answer
Doesn't have default value mysql
SQL
0 vote121 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote108 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote106 views1 answer
Sql: extract day text from datetime value
SQL
0 vote117 views1 answer
Select insert new table sql server
SQL
0 vote127 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote97 views10 answers
Sql statement checker corrector
SQL