SQL - Part 79 - Case, When, Then and End Keywords

View Notes Here - www.evernote.co...
In this video, I have explained and practically demonstrated using the 'Case','When','Then' and 'End' Keywords in SQL statements.

[@criclal1787]

First of all thank you for the video! I have a doubt... Is there a way to order the data in ascending if Country is in ('USA','UK') and in descending if Country is not in ('USA','UK')?

[@RitabrataDas-il7my]

same question @QAFox sir

[@aishwaryadashputre4415]

it is showing the error in syntax i have written as it is and your code got run why there is error in syntax in w3school please let me know

[@aniketkarade8442]

use same statement in w3school 1.0 tryit editor it will work i got the same problem before may be a technical issue

[@anjalinayak1001]

Thank you sir

[@QAFox]

Welcome :)