select deptname from department where salary>=5000

i need to know how i display department which has salary >
=5000 for the below table
Department
-----------
salary deptname
1000 a
3000 a
2000 b
3000 b
4000 c
5000 c

kindly send the query to thilakvinoth13@gmail.com

Question Posted / guest

6 Answers
7571 Views
I also Faced
E-Mail Answers

Answer Posted / guest

select deptname from department where salary>=5000

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain view in sql server?

1009

What have included columns when we talk about sql server indexing?

992

What is transaction server implicit?

949

What is candidate key with example?

925

How to select some specific columns from a table in a query in ms sql server?

946

What is tabulation?

899

What does nvl stand for?

907

How can we migrate from SQL server to SQL Azure?

113

Does partitioning improve performance?

920

What are the differences between local and global temporary tables?

1016

What do you mean by a dependent functionality in a build?

1066

List the advantages of using stored procedures?

999

What is the difference between seek predicate and predicate?

988

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

895

How many types of built in functions are there in sql server 2012?

876