Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7901 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 microsoft sql server?
Explain the purpose of indexes?
What is the use of set nocount on/off statement?
How to delete all rows with truncate table statement in ms sql server?
Explain the difference between clustered and non-clustered index?
How to execute a stored procedure in ms sql server?
What do you know about normalization and de- normalization?
How you can add messages to the nt event log from within a stored procedure?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
How to create a dml trigger using create trigger statements?
How to check status of stored procedure in sql server?
What is the difference between a clustered index and a non-clustered index?
How many instances per computer are there in sql server 2000?
What is sql server schema compare? How we can compare two database schemas?
What does the not null constraint do?
