select top 3 from papers where kind='1类' and ...其他条件 union all select top 2 from papers where kind='2类' and ...其他条件 union all select top 4 from papers where kind='3类' and ...其他条件
最好能抽出的所有记录point总和为100
--这样写:select * from(select top 3 *,aa=newid() from papers where kind='1类' and ...其他条件 order by newid())a union all select * from(select top 2 *,aa=newid() from papers where kind='2类' and ...其他条件 order by newid())a union all select * from(select top 4 *,aa=newid() from papers where kind='3类' and ...其他条件 order by newid())a
select top 3 from papers where kind='1类' and ...其他条件
union all
select top 2 from papers where kind='2类' and ...其他条件
union all
select top 4 from papers where kind='3类' and ...其他条件
union all
select * from(select top 2 *,aa=newid() from papers where kind='2类' and ...其他条件 order by newid())a
union all
select * from(select top 4 *,aa=newid() from papers where kind='3类' and ...其他条件 order by newid())a