4 SQL CASE Statement

Question 1

CASE

Answer 1

we will write condtitio in the column section

Question 2

eg of case

Answer 2

select case : when conition then ‘ message’ end

Question 3

else in case

Answer 3

if all case condition are not right then this else part will execute.

Question 4

is end manditory

Answer 4

yes

Question 5

Transposing

Answer 5

making horizontal table to vertical table

Question 6

syntax of transpose

Answer 6

select sum (case when condn then 1 else 0 end )