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

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3583

What are the benefits of using the db2 database?

1235

What is a db2 table?

1024

What is the difference between drop table and delete table?

1218

Is db2 a database?

984

On which levels locks can be applied?

1143

What is the role of schema in the db2 database?

1279

What is null indicator in cobol db2?

1069

How to create backup table in db2?

1098

What are the prerogatives?

1085

What is db2? Explain.

1052

Which are the db2 tools to protect integrity of the database?

1124

What is rebind in db2?

1073

How can you find out the # of rows updated after an update statement?

1116

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2222