.NET and SQl Server interview questions :- Typical Complicated SQL query asked in .NET interviews to test your SQL CASE syntax capability?

 Posted by ArticlesMaint on 4/25/2011 | Category: Sql Server Interview questions | Views: 2849

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.


 when (Emp_Salary>13000) then 'Greater than 13000'
 else 'Lesser than 13000'
 end as Status
 FROM Employee


Emp_Name Status
Shiv Greater than 13000
Raju Greater than 13000
Sham Greater than 13000
Moosa Lesser than 13000
Firoz Lesser than 13000

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


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response