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
- 12361 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
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
How do I import data from excel to db2?
What is a db2 cursor?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
what is db2 restart?
What is ibm db2 used for?
Which are the db2 tools to protect integrity of the database?
How to get the ddl of a table in db2?
what is the responsibility of the construction superintendent
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is the difference between bind and rebind in db2?
What is iseries database?
What type of database is db2?
What do you mean by rollback?
Mention the different locking levels that are available in db2.
What are foreign keys in db2?
