<span style="color: #3c3e41; background-color: #ecf0f3;">Scaz is a place dedicated to providing the content, tools and services you need to learn and succeed in making money online.</span>

Unique Keyword in SQL

The UNIQUE keyword is used to retrieve the unique records by eliminating the all duplicate records.

Syntax:

SELECT UNIQUE column1, column2,.....columnN FROM tableName WHERE [condition]

UNIQUE and DISTINCT statements are the same and will give the same result sets.

Example:

SELECT UNIQUE EMP_NAME FROM EMPLOYEE;

Output:

EMP_NAME
Nidhi
Parbhjot
Parmender

One reply on “Unique Keyword in SQL”

Leave a Reply