Hi dear, 1) If you have need name of total salary of each department to sp

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 / mahesh

6 Answers
7793 Views
I also Faced
E-Mail Answers

Answer Posted / mahesh

Hi dear,
1) If you have need name of total salary of each department to spend on employee(Understand like this) then use query:
select deptname, SUM(salary)
from Department
GROUP BY deptname
HAVING SUM(salary) >= 5000;

2) Otherwise

SELECT deptname
FROM Department
WHERE salary >= 5000;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an entity-relationship diagram (erd)?

1184

Why does sql studio use a single registered database repository? : sql server management studio

981

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

929

What is view in sql?

883

Difference between group by clause and having clause in SQL?

955

What the different components in replication and what is their use?

936

What is use of dbcc commands?

1049

What are security principals used in sql server 2005?

954

Explain what are sparse columns?

970

What are exact numeric data types in ms sql server?

1051

What is 2nf normalization?

1001

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

938

whats new about truncate in sql server 2008?

2486

How do you trace the traffic hitting a sql server?

1121

How can we migrate from SQL server to SQL Azure?

113