Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 are the full forms of spufi and dclgen and why are they used?

1091


Explain the contents that are a part of dclgen.

1093


List down the types of triggers in the db2 database?

1033


What is the result of open cursor statement?

1083


What is copy pending and check pending in db2?

1005


How can you classify the locks in db2?

1090


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

2128


What is table space in db2?

1019


What are db2 tables?

1126


Why select is not preferred in embedded sql programs?

1302


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

1116


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2727


What is bind plan?

1049


How do I start db2 in windows?

1097


What is bind in db2?

1050