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 votes131 views1 answer
Sql like variable
SQL
0 vote131 views1 answer
Remove default constraint sql server
SQL
6 votes143 views1 answer
Postgres get size of database
SQL
1 vote131 views1 answer
Mysql login console
SQL
0 vote142 views1 answer
Set a value by excuting stored procedure
SQL
0 vote145 views1 answer
Const pool = mysql.createpool()
SQL
0 vote136 views1 answer
Sql select duplicates based on two columns
SQL
0 vote148 views1 answer
Empty table sqlite
SQL
0 vote138 views1 answer
Split string by comma in sql server
SQL
0 vote138 views1 answer
Alasql delete column
SQL