Wednesday, 30 March 2011

SELECT DISTINCT:

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

No comments:

Post a Comment