hi all,

i need to know how i can append at new table,from table1 as...
i have 3 area(1,2,3) ,every area have 3 days(1,2,3),
i need to get randomly 800 records for each day,for every area.

that mean area1 have 2400 records from 3 days
         area2 have 2400 records from 3 days
         area3..............................

thanks.