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 ?
- 8 Answers
- 11810 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
select * from employment where salary between 1000 and 5000
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
How can we read records for specific member in CL? AND rpg?
What is view db2?
Explain about open switch business continuity software?
How can we retrieve the total number of records in RPG & CLLE?
What is copy pending status in db2?
What is a dbrm in db2?
What is the advantage in De-normalizing tables in DB2?
Comment whether the cursor is closed during commit or not.
What is the clustering index in the db2 database?
What is a db2 tablespace?
can we view the access paths created by dbrm ? how ? thx
How can record locking be achieved in those DB2 versions which do not support it?
Why do we need reorg in db2?
How can you quickly find out the # of rows updated after an update statement?
Why do chiropractors use drop table?
