SQL Query

Question

hi Sir in my project there is a table emp_info have three field employee name address and salary. and i want to show record like that if employee salary > 25000 show manager salary>15000 and how can we get this record advised me a proper query ?

Senthilkumar · Answer

Hi SELECT employeename AS [Employee Name] 'Designation' = CASE WHEN salary WHEN salary > 15000 AND salary WHEN salary > 25000 THEN 'Manager' END address salary FROM emp_info

Utpal Patel · Answer

you need to use CASE WHEN Statement in SQL Query SELECT Emp_Name Emp_Address Emp_Salary  CASE WHEN Emp_Salary > 25000 THEN 'Manager' WHEN Emp_Salary > 15000 AND Emp_Salary ELSE 'Trainee' END AS Designation From Employee_M