I would do
select * into mynewtable
from myoldtable ORDER by random() LIMIT 15000
where 15000 in this case is *.6
If you want to create another table with 40% of the
remaining data then something like
select * into mynewtable2 from myoldtable where
myoldtable.primarykey
On Tue, Oct 17, 2006 at 03:39:21PM +0800, Felix Zhang wrote:
> I want to split a table to 2 small tables. The 1st one contains 60%
> records which are randomly selected from the source table. How to do
> it?
i do my A/B-Group splitting usually by &1 the serial of the table.
assuming, that there