select * into c FROM a TABLESAMPLE (5 PERCENT)select top 5 per * into c from a order by newid()select top 5 * into c from a where i ...
select * into c FROM a TABLESAMPLE (5 PERCENT)
select top 5 per * into c from a order by newid()
select top 5 * into c from a where id<10 order by newid()
原标题:数据库表A中随机X条数据满足N条件的数据插入到表B中
关键词:数据库
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。