Codechef4u is a community for computer professionals,by computer professionals,just like you; who loves sharing and helping each others,Join them
Share your post

SQL SELECT DISTINCT statement

The SQL SELECT DISTINCT statement is used to remove duplicates from the result set of a SELECT statement and return only distinct values.

Syntax:

SELECT DISTINCT column 1,column 2…..column n
FROM table_name;



Example:

SELECT DISTINCT CategoryName,[Description] FROM Categories

Result:


Example with all columns:

SELECT DISTINCT * FROM Categories 

In this example distinct keyword compares all column values if found different all columns values then only return distinct values. 

Result:

above original diagram with duplicate values.



Invalid entry,please enter valid data.

Loading