ADDING TO ans1 no need to write perform direct use below query selec

How can you split a table in to exactly half?

Question Posted / sachin

Answer Posted / sachin

ADDING TO ans1
no need to write perform

direct use below query

select * from table fech first :b rows only.

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a plan and package in db2?

1043

What is reorg?

1071

What is a cursor in programming?

1014

What is a trigger in the db2 database?

1014

What is the maximum size of a char data type in db2?

964

Comment whether the cursor is closed during commit or not.

1040

can we view the access paths created by dbrm ? how ? thx

6973

What is the purpose of using commit?

1040

What is cobol db2?

933

What is null indicator in db2?

1051

How can you quickly find out the # of rows updated after an update statement?

985

What are the two types of logging in the db2 database? Explain them.

1017

define clustering index.

978

What is rebind in db2?

999

What is cursor with hold option in db2?

1010