SELECT * 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 / chandra10shekhar

6 Answers
7896 Views
I also Faced
E-Mail Answers

Answer Posted / chandra10shekhar

SELECT * FROM department WHERE salary>=5000

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Where is localdb stored?

945

How to use user defined functions in expressions?

1092

What is local temp table?

966

Can a table have 2 primary keys?

987

What does normalization do to data?

1075

What are the dmvs?

1015

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

958

What is reportserver and reportservertempdb ?

152

What is the purpose of the tempdb database?

1001

How to create a trigger for insert only?

1045

Explain in brief about Microsoft SQL server?

1101

Do you know what is a trace frag? Where do we use it?

1002

What is named calculation? : sql server analysis services, ssas

988

Can you roll back the ddl statement in a trigger?

979

How can you insert null values in a column while inserting the data?

1286