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 vote146 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote125 views1 answer
Oracle search columns in schema
SQL
0 vote124 views1 answer
Deny select insert update delete sql
SQL
7 votes138 views1 answer
Buy forge mods server hosting
SQL
-1 vote112 views2 answers
Sql query examples
SQL
1 vote125 views1 answer
Hexadec to sql REDSHIFT
SQL
4 votes128 views1 answer
Datepart postgres
SQL
5 votes145 views1 answer
How to use rank function in sql
SQL
0 vote145 views1 answer
Psql check table fields
SQL
2 votes149 views1 answer
Sql get the name of user pc
SQL