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 vote220 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote208 views1 answer
Create bdd mysql
SQL
0 vote204 views1 answer
Sql examples from framework
SQL
10 votes209 views2 answers
Mysql drop database if exists
SQL
3 votes179 views1 answer
Insert into table from another table mysql
SQL
0 vote197 views2 answers
Sql update multiple tables
SQL
0 vote194 views1 answer
Mysql url data type
SQL
0 vote189 views4 answers
Sql year
SQL
1 vote207 views1 answer
Oracle get current schema
SQL
5 votes201 views1 answer
Oracle create table comment
SQL