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

select salary from employment
where sal between 1000 and 5000

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does a deadlock mean in DB2?

653


What is null value in db2?

569


Why do chiropractors use drop table?

665


Where do you specify them?

681


What is package in db2 mainframe?

559






How to test SQL -911 error while developing COB-DB2 program

6721


Define sqlca.

651


How do I add a column in db2?

596


How many databases are there?

595


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

662


Are view updateable?

631


What is the use of with ur in db2?

622


How would you find out the total number of rows in a db2 table?

580


How many databases can be created inside an instance in db2 ?

605


What are concurrency issues?

632