use this, select dept from employee group by dept having sum(salary)&g

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

Question Posted / vinothmca21

6 Answers
7792 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

Please Help Members By Posting Answers For Below Questions

When should you use an instead of trigger?

944

What is indexing and its types?

999

Can we write trigger for view?

994

Difference between DELETE and TRUNCATE?

1033

What is the purpose of optimization?

980

What is dbcc command in sql server?

1068

List out the difference between union and union all in sql server?

969

what type of index will get created after executing the above statement? : Sql server database administration

961

What is sql service broker?

964

What is a partition key?

932

What is difference between rownum and rowid?

884

You want to implement the one-to-many relationship while designing tables. How would you do it?

938

Explain the difference between HTTP and HTTPS in database?

1013

What is a ddl statement?

891

How to return the top 5 rows from a select query in ms sql server?

1110