Sign Up Login


  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

Give an example of why you would want to denormalize a database

0 Answers  

what is raid? : Sql server database administration

0 Answers  

How to apply filtering criteria at group level with the having clause in ms sql server?

0 Answers  

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

Disadvantages of the indexes?

0 Answers  




What do you understand by mirroring and mention the advantages of the mirroring?

0 Answers  

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  

Which index created when Create Index on table(col), Why

2 Answers   CGI,

What do you mean by an execution plan? How would you view it?

0 Answers  

What is policy management?

0 Answers  

Do you know data definition language, data control language and data manipulation language?

0 Answers  

What is save transaction and save point?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories