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 vote173 views1 answer
Sub blocks in sql
SQL
0 vote202 views1 answer
Casterar postgres
SQL
0 vote249 views1 answer
Prisma transaction
SQL
0 vote218 views1 answer
Into operator in sql
SQL
7 votes237 views5 answers
Sql remove spaces
SQL
0 vote193 views1 answer
Mariadb LOAD DATA INFILE
SQL
3 votes188 views2 answers
Oracle sql truncate table
SQL
2 votes298 views1 answer
How to select from mssql
SQL
0 vote302 views1 answer
Mysql edit trigger
SQL
1 vote201 views1 answer
Best configuration for display table in sqlplus
SQL