Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000

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 / mdniyaz.ahmad

3 Answers
4649 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C sele..

Answer / maulesh

Select Deptname
From Department
Where salary >=5000

Is This Answer Correct ?

10 Yes

0 No

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C sele..

Answer / praveen s

Is This Answer Correct ?

6 Yes

1 No

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C sele..

Answer / rajkumar

Select Deptname from Department Where salary >=5000

Is This Answer Correct ?

1 Yes

0 No

Post New Answer