List of T SQL Interview puzzles – Outputs | SQL Tricky Puzzles | SQL OUTPUT PUZZLES


List of T SQL Interview puzzles – Outputs | SQL Tricky Puzzles | SQL OUTPUT PUZZLES

Here I come with cunning SQL Queries / Puzzles which are frequently asked in SQL / Database / MSBI / SQL BI interviews from developer to Architect level. All the questions below seems easy but it would be complex situation when you face these query in Interview time.

If you have any puzzle in mind or if you want me to solve some puzzle or if you have difficulty in solving business problem please email me @ pawankkmr@gmail.com. I would be happy to help.

This would be best for you to go through following Interview questions / puzzles before attend any technical interview. 

Please visit T-SQL Puzzles section where we have to write the query based on the scenario given by the interviewer.

Sr No T-SQL Output Interview Puzzles
36 SQL | The JOINs Puzzle-II
35 SQL | The IN & NOT IN Puzzle
34 SQL | THE BIT Puzzle
33 SQL | The CASE Puzzle
32 SQL | The Comma Puzzle
31 SQL | The Add and ALTER Puzzle
30 SQL | The Variable Assignment Puzzle-1
29 SQL | The Round Puzzle
28 SQL | The Variable Assignment Puzzle
27 SQL | The True and False BIT Puzzle
26 SQL | The NULL and UNION Puzzle
25 SQL | The Concatenation Puzzle
24 SQL | Selecting NULL in SP Puzzle
23 SQL | The alias Puzzle
22 SQL | THE RIGHT Puzzle
21 SQL | Group By Null Puzzle
20 SQL | The Division Puzzle
19 SQL | The Between Puzzle
18 SQL | The String & Null Puzzle
17 SQL | The Computed Column Puzzle
16 SQL | The NULL Puzzle
15 SQL | Sum and Count of Empty Set Puzzle
14 SQL | The Count Puzzle
13 SQL | The Primary Key Puzzle
12 SQL | Join Puzzle 1
11 SQL | Join Puzzle 2
10 SQL | Join Puzzle 3
9 SQL | Join Puzzle 4
8 SQL | Single Select Puzzle 8
7 SQL | Single Select Puzzle 7
6 SQL | Single Select Puzzle 6
5 SQL | Single Select Puzzle 5
4 SQL | Single Select Puzzle 4
3 SQL | Single Select Puzzle 3
2 SQL | Single Select Puzzle 2
1 SQL | Single Select Puzzle 1

226 thoughts on “List of T SQL Interview puzzles – Outputs | SQL Tricky Puzzles | SQL OUTPUT PUZZLES”

Leave a comment

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.