The distinct keyword is used with Select statement to retrieve unique values from the table. Distinctremoves all the duplicate records while retrieving from database.
Syntax for DISTINCT Keyword
SELECT distinct column-name from table-name;
Example
Consider the following Emp table.
| eid | name | age | salary |
|---|---|---|---|
| 401 | Anu | 22 | 5000 |
| 402 | Shane | 29 | 8000 |
| 403 | Rohan | 34 | 10000 |
| 404 | Scott | 44 | 10000 |
| 405 | Tiger | 35 | 8000 |
select distinct salary from Emp;
The above query will return only the unique salary from Emp table
| salary |
|---|
| 5000 |
| 8000 |
| 10000 |