Simple 👌 #sql #gender #datascience #report #dataengineering #dataanalytics #sqlserver #data

preview_player
Показать описание
You’ve most likely used the IF function in Excel or Google Sheets to define what should happen if certain conditions are fulfilled. In SQL the CASE statement functions the same way.

CASE - Evaluates a list of conditions and returns one of multiple possible result expressions.

The CASE expression has two formats:

- The simple CASE expression compares an expression to a set of simple expressions to determine the result.

- The searched CASE expression evaluates a set of Boolean expressions to determine the result.

Both formats support an optional ELSE argument.

🔥PLEASE LIKE and SUBSCRIBE🔥 - this will boost our motivation to create even more amazing videos.

Be a SQL HERO!

Simple 👌 #sql #gender #datascience #report #dataengineering #dataanalytics #sqlserver #data
Рекомендации по теме
visit shbcf.ru