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 vote174 views1 answer
How to use group_concat in sql server
SQL
0 vote191 views1 answer
Copy Table from SQL to CSV
SQL
0 vote181 views1 answer
Resullt all update knex mysql
SQL
0 vote219 views1 answer
Postgres list all triggers
SQL
15 votes192 views4 answers
Export mysql db using command line
SQL
5 votes188 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
1 vote207 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote182 views1 answer
Mysql terminal list table
SQL
1 vote172 views4 answers
Fatal database postgres does not exist
SQL
0 vote177 views1 answer
Selecting Data in SQL - Select Data
SQL