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 bind package and plan in db2?

1111

What is cobol db2?

1050

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

1087

Is db2 a mainframe?

1098

How to check table size in db2 sap?

1100

What is rebind in db2?

1121

B37 abend during spufi?

1511

Explain about rct.

1132

How to take backup of table in db2?

1128

What is dbrm? What it contains?

1217

What is the connection string to connect to the DB2 Database ?

1176

Is db2 a mainframe database?

1053

What is the role of schema in the db2 database?

1366

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1134

What are the rules for db2 programming?

1156