Sunny Shaikh

Sunny Shaikh

  • NA
  • 48
  • 23.9k

Showing the list of department in sql.

Sep 23 2014 2:50 AM
here is my table with data.
please tell me the query that how to show list of department paying total salary grater then 1500.
 
 emp_id emp_name dept_id salary
 1 James 10 2000
 2 Jack9 4000
 3 Henry 11 6000
 4 Tom 9 8000
 5 Vicky 11 7000
 6 Lora 11 5000

Answers (2)