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 vote208 views2 answers
Mysql to python pandas
SQL
19 votes197 views6 answers
What is mySQL
SQL
0 vote217 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
4 votes216 views2 answers
Linq join
SQL
12 votes206 views4 answers
Mysql version
SQL
15 votes215 views5 answers
If null mysql
SQL
0 vote220 views1 answer
Sql missing values
SQL
1 vote193 views1 answer
Column with prefix in sql
SQL
2 votes227 views3 answers
Sql truncate table
SQL
0 vote206 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL