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 vote192 views1 answer
Selecting duplicates
SQL
0 vote190 views1 answer
How to see password mysql vestacp
SQL
1 vote181 views1 answer
Postgres get timestamp
SQL
-1 vote187 views1 answer
Auto increment psql not primary key
SQL
2 votes223 views2 answers
Postgres change owner of schema
SQL
1 vote184 views3 answers
Mysql connection string
SQL
0 vote204 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote214 views1 answer
Mysql preg replace
SQL
0 vote254 views1 answer
Mac os zsh: command not found: mysql
SQL
3 votes179 views2 answers
Postgresql remove not null constraint
SQL