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 vote126 views2 answers
Default constraint in ms sql
SQL
50 votes198 views4 answers
Sql alter type of column
SQL
1 vote145 views1 answer
Oracle insert multiple rows into same table
SQL
1 vote152 views1 answer
Select not matching data with join table
SQL
0 vote145 views1 answer
Sql describe
SQL
0 vote83 views1 answer
How to get last client id sql
SQL
0 vote152 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote133 views1 answer
Show tables in cassandra cql
SQL
0 vote138 views8 answers
Convert sql query to linq online
SQL
0 vote135 views1 answer
How to take sum of column with same id in "JPQL?"
SQL