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

5 votes262 views2 answers
Oracle timestamp to date
SQL
15 votes267 views6 answers
Drop foreign key mysql
SQL
4 votes264 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote246 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote269 views4 answers
Convert databse to achieve log mode oracle
SQL
2 votes254 views1 answer
Anonymous block plsql
SQL
0 vote272 views1 answer
Select all same column value in sql
SQL
0 vote260 views1 answer
Conda install pymysql "windows"
SQL
0 vote271 views1 answer
Update and keep original value sql
SQL
3 votes264 views1 answer
Sql server version query
SQL