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 vote152 views1 answer
Display first three characters sql
SQL
5 votes156 views2 answers
Oracle apex debug mode
SQL
0 vote158 views1 answer
Postgres - Login and connect as default user
SQL
0 vote165 views1 answer
Postgres list all triggers
SQL
0 vote162 views1 answer
Vbscript clean up ADODB.Recordset
SQL
1 vote180 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote149 views1 answer
Jenkins SQLCMD run
SQL
0 vote143 views1 answer
Object Information
SQL
0 vote204 views1 answer
SQL Server Enterprise
SQL
0 vote165 views1 answer
Oracle to_number
SQL