Sunday, 1 July 2012

SQL SELECT DISTINCT Statement

SQL SELECT DISTINCT Statement

In a table, some of the columns may contain duplicate values. This is not a problem, however, sometimes you will want to list only the different (distinct) values in a table. The DISTINCT keyword can be used to return only distinct (different) values.

Example:-

SELECT DISTINCT column_name(s) FROM table_name

No comments:

Post a Comment