MSSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the DISTINCT keyword in MSSQL?

How does DISTINCT differ from using GROUP BY in MSSQL?

Can the DISTINCT keyword be used with multiple columns in MSSQL? Explain.

Explain a scenario where using DISTINCT in MSSQL would be more beneficial than using GROUP BY.

What are the performance implications of using DISTINCT in MSSQL?

How does MSSQL handle NULL values when using the DISTINCT keyword?

Describe a method to achieve the same result as DISTINCT without using the DISTINCT keyword in MSSQL.

How can you combine DISTINCT with window functions in MSSQL to get unique values along with aggregate information?

Discuss the limitations of the DISTINCT keyword in complex queries and how to overcome them in MSSQL.

In an MSSQL certification exam context, explain how to optimize a query that uses DISTINCT on a large dataset with millions of records.