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

what is the primary use of the model database? : Sql server administration

966

What is sql server query analyzer?

967

How to create a store procedure with encryption?

953

Does index speed up select statements?

978

How to create and drop temp table in sql server?

1004

A trigger can reference objects outside the current database? State true or false.

948

What are pages and extents? : SQL Server Architecture

959

What is difference between Datepart() and Datename() in SqlServer?

1158

What does Master database contains?

1085

Explain subquery and state its properties?

970

Mention what are the different types of ssrs reports?

144

What are points to remember while using the fillfactor argument?

910

How to change the ownership of a schema in ms sql server?

1096

What are the disadvantages of indexes?

998

What is difference between view and materialized view?

891