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 vote399 views1 answer
Drop view sql
SQL
0 vote352 views1 answer
Tsql find procedure with name
SQL
0 vote337 views1 answer
Raiserror nowait sql server
SQL
1 vote377 views1 answer
Postgres set column based on another column
SQL
0 vote369 views1 answer
Mysql error 1452
SQL
8 votes307 views8 answers
Second highest salary in mysql
SQL
9 votes389 views4 answers
Mysql set id auto increment
SQL
0 vote322 views1 answer
Full syntax inner join
SQL
3 votes407 views2 answers
Update part of a string in mysql
SQL
2 votes351 views3 answers
Postgresql reset auto increment
SQL