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
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
http://www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
http://www.youtube.com/subscription_c...
SUBSCRIBE TO OUR EMAIL LIST!
http://www.sqltrainingonline.com
LET'S CONNECT!
LinkedIn: / joeyblue
Watch video SQL CASE Statement | Quick Tips Ep61 online without registration, duration hours minute second in high quality. This video was added by user Joey Blue 10 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 12,473 once and liked it 309 people.