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

0 vote262 views1 answer
Select from 3 tables one is empty
SQL
0 vote266 views2 answers
Postgresql get last day of month
SQL
0 vote214 views1 answer
Oracle sql replace string in clob
SQL
2 votes277 views3 answers
Row number mssql
SQL
0 vote270 views2 answers
Sql drop view if exists
SQL
0 vote285 views1 answer
Alter table engine mysql
SQL
0 vote263 views1 answer
Get time component of datetime sql
SQL
9 votes298 views3 answers
Date format in sql
SQL
4 votes265 views1 answer
Adding data to table in sql python
SQL
0 vote304 views1 answer
Psql check table fields
SQL