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

How to access the deleted record of an event?

1092

How raid can influence database performance?

1087

What is difference between primary key and foreign key?

953

Write an sql query for deleting duplicate rows?

1039

How to check if a table is being used in sql server?

1011

What is dirty read?

1135

What are the hotfixes and patches in sql server?

1066

Is it important for a database administrator to understand the operating system and file access?

1044

How many types of schemas are there?

1094

What are the differences between web role and worker role?

124

What is cursors?

1262

Explain few examples of RDBMS?

1102

What is linked report?

137

Explain what role entity and relationship play in an ER diagram.

1115

What are the two authentication modes in sql server?

1171