i need to know how i display department which has salary >
=5000 for the below table
Department
-----------
salary deptname
1000 a
3000 a
2000 b
3000 b
4000 c
5000 c
kindly send the query to thilakvinoth13@gmail.com
- 6 Answers
- 8242 Views
- I also Faced
- E-Mail Answers
Answer Posted / vinothmca21
use this,
select dept from employee group by dept having sum(salary)>=
5000
regards,
Vinoth
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Equi join and non equi join is possible with sql server?
Can one drop a column from a table?
How to rebuild the master database?
What is self contained sub query?
What are the source of constraints?
How efficient you are in oracle and SQL server?
What is clustered index
What is a view in sql?
What is an indexed view?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is the primary use of the model database?
Why use identity in sql server?
When should you use an instead of trigger?
Does view occupy space?
Where can you add custom error messages to sql server?
