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

1 vote125 views1 answer
Mariadb case switch
SQL
3 votes136 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
3 votes128 views1 answer
Locate sql server
SQL
1 vote124 views1 answer
Sql eliminare un record
SQL
0 vote121 views1 answer
Cross apply top for each row t1
SQL
2 votes125 views1 answer
Cast string to datetime mysql
SQL
1 vote106 views1 answer
Tsql update datetime
SQL
0 vote161 views2 answers
Sql unique
SQL
0 vote125 views1 answer
How to install postgresql on wsl
SQL
2 votes125 views1 answer
Sql server conection string
SQL