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
5520 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 single-user mode?

868

What are the limitations in ssrs on sql server express edition?

175

If a table does not have a unique index, can a cursor be opened on it?

872

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

920

Can we add a cpu to sql server?

957

What samples and sample databases are provided by microsoft?

976

Does full backup break log chain?

911

Can I delete event logs?

873

List the various tools available for performance tuning?

843

How to loop through the result set with @@fetch_status?

1251

Why use “pivot” in sql server?

1041

In what sequence sql statement is processed?

953

Explain different types of locks in sql server.

1010

What is the partitioning method?

973

Can you explain important index characteristics?

937