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
7876 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 are the five characteristics of good data?

918

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

990

What are different types of views?

948

What is the difference between SQL notification and SQL invalidation?

1184

what is the sql equivaent of the dataset relation object ?

2026

How ssrs maintain security?

1086

How to write a query with a right outer join in ms sql server?

913

What is the purpose of forms?

958

What are scheduled tasks in sql server?

1080

can you implement data mining in SSRS?

148

What is log in sql server?

1146

How do I port a number to sql server?

1038

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1019

What is use of dbcc commands?

1071

How check triggers in sql server?

991