SELECT DISTINCT - Introduction and syntax
Explain the SELECT DISTINCT statement. Write SQL syntax for the SELECT DISTINCT
statement along with an example.
SELECT DISTINCT: It is used to select unique records from a
table. Some tables may have duplicate values for a column. Distinct will
eliminate these duplications.
Syntax:
SELECT DISTINCT column_name(s) FROM table_name
Example:
SELECT DISTINCT mobile_num FROM Employees
|