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

Select * from employment table where salary between 1000 to
50000

Is This Answer Correct ?    4 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define check constraint.

646


Can we update view in db2?

562


Is db2 a mainframe?

593


What is multi row fetch in db2?

612


What is a collection in db2?

584






What is bufferpool in db2?

580


What does db2 mean?

589


can we view the access paths created by dbrm ? how ? thx

6262


What is load utility in db2?

669


what are bind concepts in db2 cobol?

653


Explain about dbrm.

609


List down the types of triggers in the db2 database?

594


B37 abend during spufi?

984


What is the clustering index in the db2 database?

586


What is precompiler in db2?

589