Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
Showing the list of department in sql.
Sunny Shaikh
Sep 23 2014 2:50 AM
790
Reply
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
Jack
9
4000
3
Henry
11
6000
4
Tom
9
8000
5
Vicky
11
7000
6
Lora
11
5000
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
How update a date column into another format?
How can I fetch 10 random values from 50k rows fastly