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
Mention the different locking levels that are available in db2.
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What's The Error Code For Unique Index Voilation?
How connect db2 database to datastage?
What is the use of runstats in db2?
What is the usage of open cursor command?
What is access path in db2?
What is package in db2 mainframe?
What is the use of reorg in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the reason behind not using select * in embedded sql programs?
What is cursor stability in db2?
Which components manage deadlocks in db2?
How do I delete a column in db2?
Explain db2.