How can you split a table in to exactly half?
- 7 Answers
- 13887 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
Why do we use cursor?
What is the difference between nvl and coalesce?
What is view db2?
What is reorg?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How to get the ddl of a table in db2?
What is buffer pool?
What is concurrency?
What is a cursor in programming?
Mention the definition of cobol in varchar field.
What is the advantage in De-normalizing tables in DB2?
List some fields from sqlca?
What is host variable in db2 cobol?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
