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

How do I add a column to a table in db2?

1051

Explain the function done by data manager?

1221

What is db2 optimizer?

1181

What do you mean by rollback?

937

How to create db2 table in mainframe?

1105

What is collection in db2 bind?

964

How to take backup of table in db2?

1023

How to retrieve rows from a db2 table in embedded sql?

1330

What is runstats db2?

967

How do I delete a table in db2?

1010

What is the maximum size of a char data type in db2?

967

On which levels locks can be applied?

1065

How do I add a column to an existing table in db2?

979

What is explain in db2?

964

How many types of page locks can be held in db2?

996