Shubham Srivastava

Shubham Srivastava

  • NA
  • 8.7k
  • 2.3m

SQL Query

Apr 10 2012 12:46 PM
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 <=25000 are supervisor and salary<=15000 are trainee.
how can we get this record advised me a proper query ?

Answers (2)