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

How to rebuild all indexes on a single table?

0 Answers  

Is it possible to create trigger on views?

0 Answers  

What are ddl triggers and types of ddl trigger?

0 Answers  

How do you test your database? : sql server database administration

0 Answers  

How to apply cascading referential integrity in place of triggers?

0 Answers  




What do you understand by the data quality services in sql server?

0 Answers  

How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,

What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  

what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 Answers  

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

what are different types of backups available in sql server? : Sql server database administration

0 Answers  

Does a server store data?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories