MSSQL DATABASE INTERVIEW QUESTIONS

What is the equivalent of the LIMIT keyword in MSSQL, and how is it used?

How do you use the TOP clause with a percentage in MSSQL?

What is the difference between the TOP clause and the FETCH clause in MSSQL?

How do you use the OFFSET and FETCH clauses together in MSSQL?

Can you use the TOP clause with an ORDER BY clause in MSSQL? Provide an example.

How do you paginate results using the OFFSET and FETCH clauses in MSSQL?

How do you optimize queries that use the TOP, OFFSET, and FETCH clauses in MSSQL?

How do you handle ties when using the TOP clause with the ORDER BY clause in MSSQL?

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

Explain a scenario where using the TOP, OFFSET, and FETCH clauses in MSSQL is crucial for a business application and describe how you would implement it.