The UNIQUE keyword is used to retrieve the unique records by eliminating the all duplicate records.
SELECT UNIQUE column1, column2,.....columnN FROM tableName WHERE [condition]
UNIQUE and DISTINCT statements are the same and will give the same result sets.
SELECT UNIQUE EMP_NAME FROM EMPLOYEE;
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 […]