一直以来,总是被困于一旦sql 语句,子查询中有order by 就出错的烦恼,没想到用这一招就解决了,无意中发现,确成了解决方法,。
解决方法是:只要在2个select 后加上一个top 1000000,就行了。呵呵
'select top 10000000 * into uuu from ( Select top 10000000 Id From aaa order by sort) a'
-- 先把重复记录提取唯一值,再汇总!
select top 10000000 SUM(aaa) from (Select top 10000000 MAX(money) as aaa From der group by ddh order by ddh) a