select * from deptname 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 / arbind panigrahi

6 Answers
8125 Views
I also Faced
E-Mail Answers

Answer Posted / arbind panigrahi

select * from deptname where salary<=5000

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you mean by data integrity?

1127

What are the characteristics of modern DBMS?

1140

What is a group function explain with an example?

1040

How secure is sql server database?

1067

What is a subquery in a select query statement in ms sql server?

1188

What is resource governor in sql server?

1049

How can change procedure in sql server?

1129

Do you know what are acid properties?

1122

What are the advantages of stored procedure in sql server?

932

What is the index requirement in SQL Azure?

What is a cache in ssrs?

138

What is sql azure database?

206

What is the purpose of the tempdb database?

1046

How can we call UDF(User Define Function) using C# code in ASP.net ?

6949

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1107