SQL Server Course for Beginners with 100+ examples - SELECT DISTINCT Statement in SQL

This video tutorial explains how to use the 'distinct' command in MS SQL Server to filter and display unique records from a database table. It demonstrates fetching all records from an employee table and then using the 'distinct' command to show only unique city names, eliminating duplicates. The tutorial provides step-by-step instructions on executing SQL queries to achieve this result.

What is the purpose of using a distinct command in SQL?

• To retrieve unique records

• To insert new records

• To update records

• To delete duplicate records

Which SQL command is used to fetch all records from a table?

• SELECT *

• SELECT ALL

• SELECT DISTINCT

• SELECT UNIQUE

In the context of the video, which column was used to demonstrate the SELECT DISTINCT command?

• Employee ID

• Name

• City

• Salary

What happens to duplicate values when using the SELECT DISTINCT command?

• They are updated

• They are counted

• They are removed from the result set

• They are highlighted

Which of the following values were mentioned as repetitive in the city column?

• LMN and OPQ

• ABC and PQR

• GHI and JKL

• XYZ and DEF