Write a SQL statement using DISTINCT keyword?

1.	Write a SQL statement using DISTINCT keyword?
Answer» DISTINCT Keyword: The DISTINCT keyword is used along with the SELECT command to eliminate duplicate rows in the table. This helps to eliminate redundant data. For Example: SELECT DISTINCT Place FROM Student; Will display the following data as follows : SELECT * FROM Student; Output Place Chennai Bangalore Delhi

Answer»

DISTINCT Keyword:

The DISTINCT keyword is used along with the SELECT command to eliminate duplicate rows in the table. This helps to eliminate redundant data.

For Example: SELECT DISTINCT Place FROM Student;

Will display the following data as follows :

SELECT * FROM Student;

Output

Place

Chennai

Bangalore

Delhi

Discussion