[SQL]对取出来的数据构造实验组和对照组的方法

select
    id
from tb_name
where id is not null
and cast(id%100 as int) not between 50 and 59;
--即抽取十分之一作为实验组