MSSQL DATABASE INTERVIEW QUESTIONS

What is a subquery in MSSQL, and why is it used?

How do you use a subquery in the WHERE clause in MSSQL?

Can a subquery return multiple rows in MSSQL? Provide an example.

How do you use a subquery in the SELECT clause in MSSQL?

How do you use a subquery in the FROM clause in MSSQL?

What is a correlated subquery in MSSQL, and how does it differ from a regular subquery?

How do you use a subquery with the EXISTS operator in MSSQL?

How do you use a subquery to update data in MSSQL?

. How do you handle performance issues with subqueries in MSSQL?

Explain a scenario where using a subquery is crucial for a business application in MSSQL and describe how you would implement it.