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 the picture clause of null indicator variable?

1178

How can you count the number of rows from a table tab?

1134

What is cursor in dbms?

1112

What is a db2 cursor?

1107

How to execute stored procedures?

1175

What are the bind parameters ibm db2?

1099

How to take backup of table in db2?

1121

Explain correlated sub-queries.

1093

How do you eliminate duplicate values in db2?

1262

How to find primary key of a table in db2?

1113

What is drop table?

1065

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

1084

What is role in db2?

1159

What is ibm db2 client?

1004

What is null indicator in cobol db2?

1108