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 alias in db2?

980

What is package in cobol db2?

1073

What is meant by union and union all?

947

what is db2 restart?

2097

How do we specify index to include or not during bind process.

2069

Can there be more than one cursor open for any program?

1121

What is a Foreign Key?

1033

How do I add a column in db2?

997

What is runstats and reorg in db2?

1236

What is the maximum No of rows per page?

1010

What is db2 optimizer?

1175

What is the difference between using bind () and rebind () methods of naming class?

1322

What is plan in cobol db2?

1054

Which command is used to remove all rows from a table?

1037

What is the information associated with sysibm.syslinks table?

1055