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

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

What do you mean by SQL injection attack?

0 Answers   Ittiam Systems,

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

How can we remove orphan records from a table?

0 Answers  

What is self join in sql server joins?

0 Answers  

What is scd (slowly changing dimension)? : sql server analysis services, ssas

0 Answers  

what is an extended stored procedure? : Sql server database administration

0 Answers  

what is the maximum size of a row? : Sql server database administration

0 Answers  

Explain about temporary stored procedure?

0 Answers