Breaking News
yeni film izle hd film seyret film izle

Distinct keyword in dbms

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