sfmc-sql-split-random-25-percent.sql

select top 25 percent 
de1.*
from [dataextension1] de1
left join [dataextensionsplit_1] split1 on (de1.[email address] = split1.[email address])
where split1.[email address] is null
order by newid()
/* writes to dataextensionsplit_2 */