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
8113 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

What is collation sensitivity?

1134

How can we improve performance by using SQL Server profiler?

1106

What is standby servers? Explain types of standby servers.

1051

Explain what role entity and relationship play in an ER diagram.

1111

Explain filtered indexes?

1040

What is the difference between dataadapter and datareader?

1055

How to add a new dsn with the odbc driver for sql server?

1112

What are the different normalization forms?

1162

can a table be moved to different filegroup? : Sql server administration

1018

What is RMS migrations?

2189

Can sql servers linked to other servers?

1094

What is the optimization being performed in oracle and SQL Server?

1095

Give main differences between "Truncate" and "Delete".

1150

What is data compression? : sql server database administration

1016

What is db stored procedure?

943