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 - 1 of 1 Answers


  • May 26th, 2016

  1. SELECT employee FROM TABLE name


  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