Can You Use IF Condition in SELECT Statement? #coding

Details
Title | Can You Use IF Condition in SELECT Statement? #coding |
Author | Manish Sharma |
Duration | 0:59 |
File Format | MP3 / MP4 |
Original URL | https://youtube.com/watch?v=vAujEELHO4o |
Description
Databases like Oracle and Postgres do not support IF conditions with SELECT statements. Instead, you can use a CASE statement. A CASE statement allows you to classify data into different groups based on specific conditions.
In this video, I show you how to use a CASE statement to classify customers into three groups based on their order total: New, Regular, and Premium.
-------------------------------------------------------------------------
►►►Social Media – Where I sort of Live
https://www.instagram.com/RebellionRider/
https://www.facebook.com/TheRebellionRider/
https://twitter.com/RebellionRider
https://www.linkedin.com/in/mannbhardwaj/
-------------------------------------------------------------------------
►►►Books I refer to
PL/SQL https://amzn.to/2QE1jX0
Performance Tuning https://amzn.to/2sgiAw4
1z0-071 Exam https://amzn.to/2sgfeJw
Python Programming https://amzn.to/305UEbh
-------------------------------------------------------------------------
►►►Camera Gears
► Video Gears That We Use For Creating Our YouTube Video
https://www.amazon.in/shop/manishsharma?listId=DU9UM0XL97KM&ref=idea_share_inf
► Work From Home Essential Tech That We Use Daily
https://www.amazon.in/shop/manishsharma?listId=XAZ18JLLSNB5&ref=idea_share_inf
AFFILIATE DISCLOSURE:
Some of the links used in the description will direct you to Amazon.in. As an Amazon Associate, I earn from qualifying purchases at no additional cost to you.
#RebellionRider