Help me understand, the maximum records to be fetched are 150. These records come from 4 teams.

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

Then, after deciding whose record to drop (I choose 3, the low performer:), you would need to fetch:
47 records from team 1
23 records from team 2
11 records from team 3
69 records from team 4
======================
150 records from all teams!!!




>hi,
>i'm sorry if you don't understand the last message,
>
>ok, i need your help, to insert new commands to mycode,
>to insert all records(randomly) i get it, to new table,
>and deleted from table1.
>
>thanks.master
>m.qasem