Answer / guest

select deptname from department where salary>=5000

Answer / vinothmca21

use this,


select dept from employee group by dept having sum(salary)>=
5000

regards,
Vinoth

Answer / 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;

Answer / sahil

The query will be to get the total of salary >= 5000 in a
department is :


select deptname, sum (salary) as totalsalary from Department
group by deptname

then it will shown like

deptname total salary
a 4000
b 5000
c 9000

now we will get the highest total salary from department
remember group by is always used to group-set.

select deptname, sum (salary) from Department
group by deptname
having sum (salary) >= 5000

Then you will get the answer!!

Answer / chandra10shekhar

SELECT * FROM department WHERE salary>=5000

Answer / arbind panigrahi

select * from deptname where salary<=5000

Name few of the dcl commands in sql?

0 Answers  

If user is owning any SQL Objects, can we drop that user

0 Answers  

What are the advantages of using stored procedures?

0 Answers  

What are basics of policy management?

0 Answers  

What is the difference between a fill factor of 100 and 0?

0 Answers  

What is autocommit mode in sql server?

0 Answers  

What are the common performance issues in sql server?

0 Answers  

What is sql language?

0 Answers  

Explain optimistic and pessimistic concurrency?

0 Answers  

How to select some specific columns from a table in a query in ms sql server?

0 Answers  

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

Write a SQL Query to find first Week Day of month?

2 Answers