June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
sql puzzle

SQL Puzzle – Retrieve the Unique Evens Under 10

November 21, 2023
Pinal Dave
SQL Puzzle
SQL Distinct

In that spirit, let me walk through a bite-sized SQL puzzle that helps reinforce some key concepts. Let us see Retrieve the Unique Evens Under 10 puzzle.

Read More
The Flight Connection Puzzle

SQL SERVER – The Flight Connection Puzzle

July 31, 2023
Pinal Dave
SQL Puzzle
CTE, SQL Server

Today we are going to see another such puzzle – The Flight Connection Puzzle. This blog post is going to be really fun blog post.

Read More
The Two Doors, Two Guards Puzzle

SQL SERVER – The Two Doors, Two Guards Puzzle

July 28, 2023
Pinal Dave
SQL Puzzle
SQL Scripts

I came across a puzzle about “The Two Doors, Two Guards,” popularly known as the “Two Doors Riddle” or the “Heaven and Hell Riddle”.

Read More
Unsolved CASE Expression

SQL Puzzle – Unsolved CASE Expression

April 20, 2021
Pinal Dave
SQL Puzzle
SQL CASE, SQL Scripts, SQL Server

Lots of people have asked me to share another puzzle. Well, let us see a very simple puzzle of Unsolved CASE Expression in today’s blog post.

Read More
tilde

SQL Puzzle – SELECT ~ 1 : Guess the Answer

April 9, 2021
Pinal Dave
SQL Puzzle
SQL Server

Of course, I have one where you have to guess the answer for a simple select statement. Let us see if you can guess it correctly or not.

Read More
data type

Solve Puzzle about Data type – SQL in Sixty Seconds #108

August 24, 2020
Pinal Dave
SQL Puzzle, SQL Video
Data Type, SQL in Sixty Seconds, SQL Scripts, SQL Server

A very interesting puzzle, where you see the data type conversion in action. I have previously blogged about this puzzle and had received amazing feedback.

Read More
strange results

SQL Puzzle – Solution to Strange Results – IN and IS NOT NULL –

July 10, 2020
Pinal Dave
SQL Puzzle
SQL NULL, SQL Scripts, SQL Server

Earlier I had published a blog post about a puzzle SQL Puzzle – IN and IS NOT NULL – Strange Results. Today we will see a solution to strange results puzzle.

Read More
1 2 3 4 … 28 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version