4 SQL CASE Statement Flashcards
1
Q
CASE
A
we will write condtitio in the column section
2
Q
eg of case
A
select case : when conition then ‘ message’ end
3
Q
else in case
A
if all case condition are not right then this else part will execute.
4
Q
is end manditory
A
yes
5
Q
Transposing
A
making horizontal table to vertical table
6
Q
syntax of transpose
A
select sum (case when condn then 1 else 0 end )