Discussion :: Advanced SQL - General Questions (Q.No.4)
|Kaushiki Singh said: (Mar 12, 2011)|
|I got ucase and lcase but do not understand this case sql, how it establish if-then-else- in sql ?|
|Abinayaravi said: (Oct 12, 2011)|
|This is like switch cases but used in if-then-else.|
|Hari Krishna Dondapati said: (Feb 18, 2012)|
|It is nothing but, it will checks the equality condition like where clause in normal select statement.
If value is true, then it will display corresponding value.
|Sanjay said: (Apr 29, 2017)|
|But we can use fun.UCase or LCase. Am I right?|
|Amulya said: (Dec 18, 2017)|
|Please explain, if-then_else in sql with an example.|
|Rakesh said: (Jun 4, 2018)|
|In this, we can able to write both if and else conditions ;
WHEN Gender = 'M' THEN 'Male'
WHEN Gender = 'F' THEN 'Female'
ELSE 'Unknown Value'
Post your comments here:
Email : (optional)
» Your comments will be displayed only after manual approval.