Which of the following keyword is used to eliminate duplicate records in SQL?

Explanation

The SELECT DISTINCT statement is used to return only distinct (different) values. Syntax SELECT DISTINCT column1, column2, ... FROM table_name; For example There is a table name Student_details having few attributes Student Name Department City A CSE Haridwar B CE Haridwar C ME Dehradun D CSE Rishikesh E IT Rishikesh Without DISTINCT The following statement returns all cities of all Students in the Student_details tables: SELECT city FROM Student_details; City Haridwar Haridwar Dehradun Rishikesh Rishikesh As you can see clearly from the output, the cities are duplicate. With DISTINCT SELECT DISTINCT city FROM Student_details City Haridwar Dehradun Rishikesh