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 votes183 views1 answer
Mysql application.properties spring boot
SQL
0 vote173 views1 answer
Oracle sql developer closed connection
SQL
1 vote205 views3 answers
How to update column name in psql
SQL
4 votes177 views1 answer
Mysql biginteger size
SQL
1 vote173 views3 answers
How to get date in sql
SQL
1 vote166 views1 answer
Sql auto timestamp
SQL
2 votes168 views1 answer
Sql find missing values between two tables
SQL
0 vote182 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote172 views1 answer
Java mysql swing example
SQL
17 votes240 views6 answers
Get last record in sql
SQL