1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Answers were Sorted based on User's Feedback



i need to know how i display department which has salary > =5000 for the below table Departmen..

Answer / guest

select deptname from department where salary>=5000

Is This Answer Correct ?    7 Yes 1 No

i need to know how i display department which has salary > =5000 for the below table Departmen..

Answer / vinothmca21

use this,


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

regards,
Vinoth

Is This Answer Correct ?    4 Yes 3 No

i need to know how i display department which has salary > =5000 for the below table Departmen..

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;

Is This Answer Correct ?    1 Yes 1 No

i need to know how i display department which has salary > =5000 for the below table Departmen..

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!!

Is This Answer Correct ?    0 Yes 0 No

i need to know how i display department which has salary > =5000 for the below table Departmen..

Answer / chandra10shekhar

SELECT * FROM department WHERE salary>=5000

Is This Answer Correct ?    0 Yes 1 No

i need to know how i display department which has salary > =5000 for the below table Departmen..

Answer / arbind panigrahi

select * from deptname where salary<=5000

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

State the difference between union and union all?

1 Answers  

What is the difference between seek predicate and predicate?

1 Answers  

What is a with(nolock)?

1 Answers  

What is partition in sql server?

1 Answers  

What are the difference between clustered and a non-clustered index?

1 Answers  

Explain encryption of entire databases without the need for application changes in sql server 2008?

1 Answers  

What is nested transaction?

1 Answers  

Which language is supported by sql server?

1 Answers  

What is sql server management studio? : sql server management studio

1 Answers  

What is use of except clause? How does it differ from not in clause?

1 Answers  

What is a field name?

1 Answers  

Which virtual table does a trigger use?

3 Answers  

For more SQL Server Interview Questions Click Here
Categories