select * from employment where salary between 1000 and 5000

i have an employment table whch has salary,dept,name? i want
salary b/w 1000 to 5000 can anyone pls say the query for ths ?

Question Posted / yuvaevergreen

Answer Posted / yuvaevergreen

Is This Answer Correct ?

17 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is meant by union and union all?

1014

What is the role of the data page in the db2 database?

1031

When the like statement is used?

1230

How to find the number of rows in a db2 table?

1123

can all users have the privilage to use the sql statement select * (dml)?

1180

Mention the definition of cobol in varchar field.

1253

Define sqlca.

1119

What is db2 plan table?

1054

How do I optimize a query in db2?

1105

what are bind concepts in db2 cobol?

1102

What is copy pending and check pending in db2?

1007

What is a db2 schema?

1241

What is data manager?

1056

What are packages in db2?

1028

What is a plan and package in db2?

1110