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 vote242 views1 answer
Exclude last comma separated string mysql
SQL
1 vote257 views1 answer
Database Queries
SQL
0 vote233 views1 answer
Sql waitfor
SQL
2 votes247 views1 answer
Sql percentage with % rounded down
SQL
2 votes243 views2 answers
Convert_tz mysql
SQL
12 votes224 views1 answer
Env var for setting password for root user mysql docker hub
SQL
2 votes254 views1 answer
Sql OR
SQL
0 vote253 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote246 views1 answer
Excel export from sql using python
SQL
0 vote222 views1 answer
Update set with join pl sql
SQL