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 vote239 views1 answer
Watch mysql command line
SQL
0 vote252 views1 answer
MySQL - Enabling the Event Scheduler
SQL
4 votes247 views3 answers
Employee name starting with in sql
SQL
0 vote236 views1 answer
Sql count null values in all columns
SQL
0 vote195 views1 answer
Select all domains of database firbird
SQL
0 vote235 views1 answer
Sql delete row from table where id
SQL
0 vote242 views1 answer
Acutal month year
SQL
0 vote232 views3 answers
Remove folders from remote git
SQL
1 vote217 views6 answers
In sql
SQL
2 votes247 views1 answer
Q operator in oracle
SQL