use of Distinct

Distinct

• Sometimes from data table, we may get redundant data.
• To avoid redundant output, distinct keyword is used.

Example:

select distinct CustomerName from Customers 

--get distinct name 

select distinct CustomerName,Country from Customers

--get distinct name from every country event its repeat in other country