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

1 vote340 views1 answer
Oracle lowercase
SQL
0 vote356 views1 answer
Initcap in mysql
SQL
3 votes395 views2 answers
Sql not contains
SQL
5 votes361 views2 answers
Mysql import gzip db
SQL
0 vote351 views1 answer
Postgres in operator with comma separated values
SQL
3 votes341 views1 answer
Sql cast to integer
SQL
0 vote374 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote348 views1 answer
Create new table pl sql
SQL
5 votes337 views1 answer
Oracle list packages
SQL
0 vote385 views1 answer
Mysql db dump restore max file size issue
SQL