select salary from employment where sal 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 / dd

Answer Posted / dd

select salary from employment
where sal between 1000 and 5000

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Define db2.

1120

What is the advantage in De-normalizing tables in DB2?

1189

Mention the different locking levels that are available in db2.

1140

How can deadlocks be resolved?

946

How to fetch the last row from the table in SQL (db2)?

1660

what is the role of the cursor in db2?

1071

What is access path in db2?

993

Why do chiropractors use drop table?

1115

What is release/acquire in bind?

1113

can we view the access paths created by dbrm ? how ? thx

7113

How do we specify index to include or not during bind process.

2132

What is cursor with hold option in db2?

1093

How do I delete a column in db2?

1115

What is db2 and what is the use of db2 optimizer?

1071

How do you stop a db2 database in linux?

1020