select *from emp where salary between 1000 to 50000

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 / prasanna

Answer Posted / prasanna

Is This Answer Correct ?

9 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is a collection in db2?

988

Why do chiropractors use drop table?

1049

What is cursor stability in db2?

1281

What is load utility in db2?

1132

What is the use of reorg in db2?

1027

Can you tell me how can you find out the # of rows updated after an update statement?

1048

Explain about rct.

1028

What is blu acceleration in db2?

1018

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

996

What is the role of union all and union

1074

How do you pull up a query which was previously saved in qmf?

1103

What are foreign keys in db2?

1038

Explain about dbrm.

991

How do I delete a table in database?

979

What is a bind in db2?

987