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

3 Answers
5524 Views
I also Faced
E-Mail Answers

Answer Posted / rajkumar

Select Deptname from Department Where salary >=5000

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different types of collation sensitivity?

1058

Is it possible to have clustered index on separate drive from original table location?

908

How to get the number of affected rows?

952

How to drop an existing table with "drop table" statements in ms sql server?

1038

What is query parameter in ssrs?

143

How to create database with physical files specified in ms sql server?

956

Is the order of columns in the set clause important in ms sql server?

929

Differentiate between a local and a global temporary table?

900

Explain comment on transactions?

936

How to connect ms access to sql servers through odbc?

971

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1033

What is normalization? Explain its different types?

1039

Can you create a logon trigger in sql server 2005 express edition?

1032

Do you know what are pages and extents? : SQL Server Architecture

944

How to display a past time in days, hours and minutes?

966