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”
SQL Tutorials - Scaz January 27, 2023 at 11:40 am
[…] SQL UNIQUE keyword […]