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

3 Answers
5772 Views
I also Faced
E-Mail Answers

Answer Posted / maulesh

Select Deptname
From Department
Where salary >=5000

Is This Answer Correct ?

10 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

1065

How to optimize stored procedure optimization?

968

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

989

What are transactions and its controls?

1108

Differentiate between a local and a global temporary table?

1009

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

2014

What is inline variable assignment?

1082

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2828

Indexes are updated automatically is the full-text index also updated automatically?

1072

How can you start sql server in different modes?

1021

Explain Geometry datatype in sql server 2008 with example

1049

Can a rule be bound to any column of any data type?

1025

What are the benefits and tasks of object explorer? : sql server management studio

1258

What is shrink log file?

954

What are the properties of the transaction?

1052