Question

select top 10 * from (SELECT * FROM (SELECT * FROM (SELECT 分店编号, 分店, 省份, 城市, 供应商编号,

各位sql高手帮我看看上面sql语句有什么问题，如果不要排序的话可以正常显示6条数据，如果如上面加上排序之后就没有数据显示了，是什么问题，急死我了，麻烦各位兄台了
GROUP BY 分店编号, 分店, 省份, 城市, 供应商编号, 供应商, 电话, 银行类别, 银行户名, 银行账号, dh, dh1, dh2, dh4, dh5) AS ccc11) AS cct11
WHERE cct11.供应商编号 not in (select top 590 供应商编号 from
(SELECT * FROM
(SELECT * FROM
(SELECT 分店编号, 分店, 省份, 城市, 供应商编号, 供应商, sum(进货) AS 进货, sum(支付) AS 支付, sum(退货) AS 退货, sum(其它) AS 其它, sum(je1) AS 汇总金额, 电话, 银行类别, 银行户名, 银行账号, dh, dh1, dh2, dh4, dh5 FROM

Answer 1

LIMIT 0, 1000 Error Code : 1064 You have an error in your SQL select top 10 * from pay_base where pay_bas_r001 not in (select ,aGpgvu