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
- 7569 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
How will you monitor replication latency in transactional replication? : sql server replication
What are different types of data sources?
Write an sql query to find first weekday of the month?
What is policy based management (pbm)? : sql server database administration
How do I view a stored procedure in sql server query?
What is a view and what are its advantages?
What different steps will a sql server developer take to secure sql server?
What are the 10 characteristics of data quality?
What does COMMIT command do?
How to execute stored procedure in select statement sql server?
Do you know what is xpath?
how will add additional conditions in sql?
How to create an multi-statement table-valued function?
What is CTE in SQL
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
