Перейти к содержимому

SQL CASE Statement | Quick Tips Ep61

Joey Blue

0:00 / 0:00

SQL CASE Statement | Quick Tips Ep61

14 143 просмотра · 5 лет назад
Joey Blue
160 тыс. подписчиков
14 143 просмотра · 5 лет назад
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