SQL Tricky Examples

Complete Emp and Dept table with example

Interview questions on emp and dept table (part 1)
Interview questions on emp and dept table (part 2)
Interview questions on emp and dept table (part 3)
Interview questions on emp and dept table (part 4)
Tricky interview questions employee and manager column in emp table

Tricky Interview questions: Employee and manager hierarchy within an emp table

Inner Join - different scenario examples

Left Join - tricky examples

Inner join - tricky interview questions

Left Join - Tricky interview questions

Right Join - tricky interview questions

Union Operator - tricky interview questions

Except operator - tricky interview questions and answers

Intersect operator - tricky interview questions

The EXISTS predicate - interview questions

Correlated subqueries - interview questions

Derived tables - tricky interview questions

Cross apply interview questions and answers

Outer apply interview questions and answers

Pivoting tricky interview questions

Different ways to delete duplicate records in SQL Server

Advanced string functions in SQL Server

Top Date and Time functions in SQL Server