SQL Complex queries, Query Optimization and Interview Questions

This lecture is on complex query SQL server, topic covered are:
• OUTPUT Clause
• RANK(), ROW_NUMBER() and DENSE_RANK() Function
• Query Optimization and Use of execution plan.