SQL | IIF Function | Learn a Shorthand for CASE #shorts

preview_player
Показать описание
SQL Tips - Do you sometimes get tired of writing the long CASE statements?

Do you ever wish to know a shorthand way to write the CASE function?

Well, yes, there are functions which which can be used as a shorthand for CASE.
One such function is the IIF function. Do you know any others?

Please make sure to comment below!!!

Book a private One-on-One 1 hour training session - SQL for Beginners

How to install SQL Server for practice?

Check out the complete list of SQL Query Interview Questions -

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate

Google Advanced Data Analytics Professional Certificate

Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization

Beginners to Python Programming

Data Science and Business Analytics with Python

IBM Data Science Professional Certificate

Data Science Fundamentals with Python and SQL Specialization

Python for Everybody Specialization

Google Data Analytics Professional Certificate

Coursera Plus - Data Science Career Skills

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at
Рекомендации по теме
Комментарии
Автор

SQL Tips - Do you sometimes get tired of writing the long CASE statements?

Do you ever wish to know a shorthand way to write the CASE function?

Well, yes, there are functions which which can be used as a shorthand for CASE.
One such function is the IIF function. Do you know any others?

Please make sure to comment below!!!

LearnatKnowstar
Автор

thankyou, would love for another simplified function...

rzar
Автор

Excellent 👌 and any stuff completely on advance sql? Please let us know

sureshallampalli
Автор

What will be the query if the manager colmn data in string? IIF will work for this too?

ShivBaba_official
Автор

good advice, not applicable for Oracle

MyxaTcakatuha
Автор

This Function will not work in azure Synapse..😢

chellurisatish