March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • 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
  • Training
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
strange results

SQL Puzzle – IN and IS NOT NULL – Strange Results

June 17, 2020
Pinal Dave
SQL Puzzle
SQL NULL, SQL Scripts, SQL Server

Today, let us see a very simple puzzle where we are getting strange results when using NOT IN and IS NULL in a T-SQL query.

Read More
table creation

SQL Puzzle – Schema and Table Creation – Answer Without Running Code

October 15, 2019
Pinal Dave
SQL Puzzle
Schema, SQL Scripts, SQL Server, SQL Table Operation

It has been a while we have a puzzle on this blog. Let us have a very simple and interesting puzzle today about Schema and Table Creation.

Read More
qualified

Winners and Solution – DELETE Qualified Rows From Multiple Tables

July 29, 2019
Pinal Dave
SQL Puzzle
SQL Scripts, SQL Server

As the price of this class high, I wanted to keep my contest difficult as well. Today we will see the winners and solutions.

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

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

Go to mobile version