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 vote171 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote173 views2 answers
Oracle chain rules
SQL
0 vote159 views1 answer
Mysql function variable
SQL
1 vote176 views2 answers
How to check if sql query is correct online
SQL
49 votes283 views6 answers
Install mysql ubuntu
SQL
0 vote217 views2 answers
Uninstall postgresql mac
SQL
0 vote160 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote162 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
1 vote191 views1 answer
Sql server set variable if exists
SQL
0 vote220 views1 answer
Sqlite update where exists
SQL