Display Employee SELECT SQL Query

Display employees who are IT_prog and salary is greater than 3000 and department is not equal to 80 and having the manager as 103

Showing Answers 1 - 3 of 3 Answers

Neha

  • May 26th, 2016
 

Code
  1. SELECT employee FROM TABLE name

  2.  

  3. WHERE salary > 3000 AND dept!= 80 GROUP BY IT_prog HAVING manager IN (103)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions