Loading

What is the DISTINCT statement and how do use it

What is the DISTINCT statement and how do use it

Kiran Kumar

Kiran Kumar

What is the DISTINCT statement and how do use it

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mukesh Sagar1y ago
Accepted answer
DISTINCT keyword is used to get the unique values from a database table. The syntax for the same is :

Select distinct deptno from emp;

Using this statement we get the unique department numbers avialable.
+1
Jignesh Kumar1y ago
Hi Kiran,

The DISTINCT statement in SQL is used to retrieve only unique values from a query, filtering out any duplicate entries. It is typically used with the SELECT statement to ensure that the result set contains only distinct rows.
```
SELECT DISTINCT name FROM employees;
```
0
Cynthia Sathuragiri1y ago
DISTINCT gives you only unique values, removing any duplicates.DISTINCT helps you get only one entry for each unique combination of selected columns.

SELECT DISTINCT column1, column2, ...
FROM table_name
0