How can you split a table in to exactly half?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a plan and package in db2?

627


Define check constraint.

647


What is clone table?

592


Can we delete records from view?

566


What is dpf in db2?

668






Why select is not preferred in embedded sql programs?

715


How do you simulate the explain of an embedded sql statement in spufi/qmf?

637


What db2 400?

681


Explain packages.

666


How do I start db2 in windows?

569


What is cursor with hold option in db2?

615


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

582


How does coalesce work?

588


What is the use of with ur in db2?

623


What are packages in db2?

599