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
- 12360 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
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
What action db2 takes when a program aborts in the middle of a transaction?
How do I copy a table in db2?
What is null in db2?
What is buffer pool and list some of them?
How to create db2 table in mainframe?
What is the default page size of buffer pools?
What are the 2 sqlcodes that are returned?
Explain about cursor stability?
What is the result of open cursor statement?
What is the maximum No of rows per page?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Mention the downsides of page level lock.
What is the difference between cursor and select statement?
What is the use of reorg in db2?
