Answer:
 

Let's us assume that we have the following table of Employee.

Emp_Id	Emp_Name	Emp_Salary
1	Shiv	17000
2	Raju	13500
3	Sham	15000
4	Moosa	11000
5	Firoz	12000

There can be a scenario we have to display employee name whose salary is greater than "some amount" or less than "some amount" for that purpose we use case statement.

Let's us consider that we have to display all the employee names from the employee table and the status like salary is greater than 13000 or lesser than 13000.

Query:

 SELECT Emp_Name,CASE 

 when (Emp_Salary>13000) then 'Greater than 13000'

 else 'Lesser than 13000'

 end as Status

 FROM Employee

Output:

Emp_Name	Status
Shiv	Greaterthan 13000
Raju	Greaterthan 13000
Sham	Greaterthan 13000
Moosa	Lesserthan 13000
Firoz	Lesserthan 13000

Hence you can see that all the employee name have been displayed with their salary status in the above output.

Regards,

Please click here to see more .NET and SQl Server interview questions