Press "Enter" to skip to content

mysql-distinct

MySQL DISTINCT clause

MYSQL Distinct remove duplicate row from the table when you use with select clause

SYNTAX


SELECT DISTINCT
columns
FROM
table_name
WHERE
where_conditions;

Table structure Used for Example explanation

For the example country table is used .The structure of country table is as follow:
+—————-+————+
| Field | Type |
+—————-+————+
| Code | char(3) |
| Name | char(52) |
| Continent | char(40) |
| Region | char(26) |
| SurfaceArea | float(10,2)|
| IndepYear | smallint(6)|
| Population | int(11) |
| LifeExpectancy | float(3,1) |
| GNP | float(10,2)|
| GNPOld | float(10,2)|
| LocalName | char(45) |
| GovernmentForm | char(45) |
| HeadOfState | char(60) |
| Capital | int(11) |
| Code2 | char(2) |
+—————-+————+

Example for MySQL DISTINCT clause

Select Distinct continent from country ;

Output of Above Example

mysql> Select Distinct continent from country ;
+—————+
| continent |
+—————+
| Asia |
| Europe |
| North America |
| Africa |
| Oceania |
| South America |
| Antarctica |
+—————+
7 rows in set (0.07 sec)