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 vote273 views1 answer
Mysql select where text contains
SQL
4 votes269 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
2 votes294 views2 answers
Created at and updated at in mysql
SQL
4 votes273 views1 answer
Oracle change nls_date_format permanently
SQL
2 votes305 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
2 votes304 views2 answers
Mysql add hours to time field
SQL
1 vote268 views1 answer
How to print longest name in sql
SQL
1 vote278 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote303 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote264 views1 answer
Oracle sql date summer time
SQL