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

2 votes341 views1 answer
Orcale index size
SQL
0 vote329 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
4 votes355 views1 answer
Mysql query first character
SQL
0 vote356 views1 answer
Add super privilege mysql
SQL
1 vote315 views1 answer
Create procedure with encryption
SQL
2 votes355 views1 answer
Sql server find columns list in tables
SQL
0 vote328 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote335 views1 answer
Sql server select record with max id
SQL
6 votes325 views2 answers
Oracle
SQL
1 vote329 views1 answer
SQL date part only of datetime
SQL