C

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 / praveen s

3 Answers
5516 Views
I also Faced
E-Mail Answers

Answer Posted / praveen s

Is This Answer Correct ?

6 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What command do we use to rename a database?

1010

How can sql server instances be hidden? : sql server security

1052

What are the components of dbms?

903

What is sharding?

114

What is an indexed view?

915

Explain iaas, paas and saas?

How do I find the sql server instance name?

917

How would you choose between a clustered and a non-clustered index?

915

What is difference between oltp and olap?

979

What is difference between commit and rollback when used in transactions?

902

What is a fill factor?

1032

How can I create a report based on a query? : sql server management studio

971

How are the unique and primary key constraints different?

1002

Explain primary key in sql server?

970

why would you use sql agent? : Sql server database administration

1114