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
- 6721 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
what is a correlated sub-query? : Sql server database administration
What are the different Topologies in which Replication can be configured?
How to throw custom exception in Stored Procedure?
Do you know the cursor types?
Do you have any idea about the tcl commands?
You want to use a perspective in an mdx query. How do you select the perspective?
What are the acid properties?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is function of ROLLUP ?
Explain raiserror in sql server?
What are the encryption mechanisms in sql server?
What are page splits? : SQL Server Architecture
What are the types of indexes?
What is a self join in sql server?
Do you know what are the properties of the relational tables?
