随机生成不重复的一组数据

select top 6 T1.*,newid()
 from 
(
select distinct 
substring(number,8,11) as number
from tb_entity_number where flag = 1
)  T1 order by newid()