hi,
this is what i want with small cahnges as

the maximum records to be fetched are 150. These records come from many teams.from area1

Perhaps each teams contribution to your "poll" should be calculated first. Count all (the total) the records from each team:
Team 1 has 200 records
Team 2 has 100 Records
Team 3 has 50 Records
Team 4 has 300 records
Total records from all teams = 650

Team 1 percentage of all records = 200/650 = 31% or 47 records of 150 records
Team 2 percentage of all records = 100/650 = 15% or 23 records of 150 records
Team 3 percentage of all records = 50/650 = 8% or 12 records of 150 records
Team 4 percentage of all records = 300/650 = 46% or 69 records

? 47+23+12+69 = 151 records

i want to insert all records under to new table, and deleted form table1
47 *4 records from team 1
23 *4 records from team 2
11 *4 records from team 3
69 *4 records from team 4
======================
580 records from all teams!!!

next area

thanks.