Interested to Buy Any Domain ? << Click Here >> for more details...
How can you split a table in to exactly half?
- 7 Answers
- 16168 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
List out the buffer pools in db2
What is the reason behind not using select * in embedded sql programs?
What is bufferpool in db2?
Where do you specify them?
what is the sqlcode -501
What is scrollable cursor in db2?
Which component is responsible for db2 startup and shutdown?
What is declare cursor?
When the like statement is used?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How to restart a DB2 program?
How to run db2 command in windows?
What happens in bind step in a db2 program?
What is the physical storage length of time data type?
What are the uses of db2 optimizer?
