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 ?

Answer Posted / prasanna

select *from emp where salary between 1000 to 50000

Is This Answer Correct ?    9 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is access path in db2?

560


What is db2 look?

572


Explain the function of data manager.

632


How do I delete a table in database?

595


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

1674






How to check last update on table in db2?

624


Explain dclgen.

720


What do you mean by storage group (stogroup)?

578


How connect db2 database to datastage?

757


What is the difference between oracle and db2?

583


List out the data types available.

695


What is database reorganization?

587


What is a plan and package in db2?

615


How do I start db2 in windows?

554


What is syscat in db2?

573