How can you split a table in to exactly half?
- 7 Answers
- 13852 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / kumar
Hi ............
try this one ....might be a logical one ... but have to
give customers what they want.....
Select count(*) into :ws-count from emp with ur;
Declare CURSOR cursor1 for
Select *(if possible better code all fields)
from emp where count(*) < :ws-count;
Open cursor
Fetch cursor.
Declare CURSOR cursor2 for
Select *(if possible better code all fields)
from emp where
count(*) >= :ws-
count;
Open cursor
Fetch cursor.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is innodb buffer pool?
How does cobol compile db2 program?
Mention the downsides of page level lock.
What are the contents of dclgen?
What is cursor stability in db2?
Outputs of explain are with matchcols = 0. What does this signify?
List down the types of triggers in the db2 database?
How is a typical db2 batch pgm executed?
What is database alias db2?
What is the purpose of rollback and commit?
What is page size in db2?
Why do chiropractors use drop table?
What is copy pending and check pending in db2?
What is the maximum size of varchar data type in db2?
Why do we use cursor?
