Select Deptname from Department Where salary >=5000

Department
-----------
salary Deptname
1000 A
3000 A
2000 B
3000 B
4000 C
5000 C

select the deptname where salary >=5000

result should be:
Deptname
---------
C

please post only executed query in SQL server 2005
Asked By: Md. Niyaz

Question Posted / rajkumar

3 Answers
5616 Views
I also Faced
E-Mail Answers

Answer Posted / rajkumar

Select Deptname from Department Where salary >=5000

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is raiseerror? What is raiseerror?

1119

What is the difference between clustered index and primary key?

900

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1087

Will sql server 2005 allow you to reduce the size of a column?

967

What is database white box testing?

1109

What is master database? : SQL Server Architecture

1002

Define Business Edition in SQL Azure?

100

How to drop an existing stored procedure in ms sql server?

1016

How much does sql server 2016 cost?

1037

Write an sql query to find first weekday of the month?

903

Can we use where and having clause together?

1024

Where are SQL server users names and passwords are stored in sql server?

1241

Do you think BCNF is better than 2NF & 3NF? Why?

1259

What is the default Port No on which SQL Server listens?

1108

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1839