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
5769 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 is an sql server agent?

1114

query processing

2221

How to retrieve error messages using mssql_get_last_message()?

1103

How to send email from database?

1072

What are the different ways you can create databases in sql server?

1156

ow to bring suspect mode datbase online from scratch

1857

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1112

What command is used to rename the database?

1087

Do you know the capabilities of cursors?

1221

How is SQL Azure different than SQL server?

225

What is the maximum size of a row in sql server?

1006

What is the purpose of sql profiler in sql server?

1067

Why olap is used?

1035

How do I make a resultset scrollable?

1014

What purpose does the model database server?

1147