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 vote252 views1 answer
Openquery insert into linked server
SQL
0 vote262 views1 answer
What is the difference between now() and current_date()?
SQL
1 vote247 views1 answer
Crontab every month
SQL
0 vote238 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote253 views1 answer
Sql include rows with 0 values
SQL
0 vote255 views1 answer
Oracle merge insert if not exists
SQL
14 votes266 views3 answers
Delete all records from table except sql
SQL
4 votes296 views4 answers
Mysql get date from datetime
SQL
0 vote255 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote269 views1 answer
Oracle list datafiles
SQL