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

How do we synchronize On-Premise SQL server with SQL Azure?

120

Write a SQL query in order to merge two different columns into single column?

1022

What is the difference between count and distinct count?

871

Explain the difference between primary keys and foreign keys?

1003

What are triggers in ms sql server?

1144

What is Command line parameters in PLSQL.?

1110

Tell me in brief how sql server enhances scalability of the database system?

974

what are the Prerequisites for Replication?

11323

What is key attribute?

914

What are security principals used in sql server 2005?

954

How many types of objects are there?

987

What is the use of @@spid?

983

What are the indexes in sql server?

1095

What are the properties of the transactions?

1099

What is the purpose of data source?

1017