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 vote335 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote331 views1 answer
Sqlserver now
SQL
0 vote348 views1 answer
Less than and between in sql query
SQL
0 vote351 views1 answer
Sql select most frequent value in column
SQL
0 vote336 views1 answer
Sql last 7 days
SQL
2 votes367 views3 answers
Current setting postgres timezone
SQL
0 vote339 views1 answer
Alter table myisam to innodb
SQL
0 vote363 views1 answer
Dump only data
SQL
0 vote367 views1 answer
Mysql wait_timeout
SQL
25 votes350 views6 answers
Change column name mysql
SQL