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
5608 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

Explain what is dbcc?

994

what are the reporting service components in SSRS?

163

How will you know when statistics on a table are obsolete?

1063

Explain transaction isolation levels in sql server?

1089

How retrieve field names from the table in SQL through JAVA code?

1881

define and explain the differences between clustered and non-clustered indexes.

1170

SQL Server Architecture ?

2432

How to fine-tune reports?

264

Is it possible to replicate data from sql server to oracle? : sql server replication

1070

Is mysql better than sql server?

1044

What are advantages of ssrs or why we should use ssrs?

137

what is sql server? : Sql server database administration

969

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1009

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1175

Why union all is faster than union?

892