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

Is db2 free?

1092

How do you concatenate the firstname and lastname from emp table to give a complete name?

1073

What is database reorganization?

1123

Which components manage deadlocks in db2?

1064

What is db2 purescale?

993

List out the buffer pools in db2

1072

List some fields from sqlca?

1056

Who uses db2?

1034

what is db2 restart?

2149

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

1110

What is the physical storage length of time data type?

1123

What is meant by dclgen?

1103

What are types of indexes?

1066

How to retrieve rows from a db2 table in embedded sql?

1385

What is data manager?

1046