SQL CASE Statement | Quick Tips Ep61

preview_player
Показать описание
In this video I show you 3 different ways to use the SQL Case Statement. I demonstrate the Simple CASE expression, the Searched CASE expression, and add in some other decoding and bucketing. The demonstration uses SQL Server and SQL Server Management Studio (SSMS).

SQL CASE Statement | Quick Tips Episode #61

TABLE OF CONTENTS
0:00 - Intro
0:47 - Simple CASE Expression Example
3:50 - Searched CASE Expression Example
5:05 - GPA Bucketing Example
7:29 - Example of Changing Order of WHEN Clause
8:58 - Between Example in WHEN Clause

YOUTUBE NEWS UPDATES

VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS

SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!

SUBSCRIBE TO OUR EMAIL LIST!

LET'S CONNECT!
Рекомендации по теме
Комментарии
Автор

Your tutorials demonstrate exceptional pedagogy. A model for online education.

palmerimsoaresdesa
Автор

Best explanation of sql case I’ve found!

_indrid_cold_
Автор

That's very helpful. I thank you a lot!

dawitworku
Автор

what's the difference between case and if, anyone knows?

Maldive
Автор

Thank you for your videos. I am learning SQL on Coursera and compared to what you do, those lessons are really poor quality.

nkv