语句总是报错:S

[hqbj08]

SELECT TOP 10 * FROM AN_Product
WHERE
(PdtID >
(SELECT MAX(PdtID) FROM (SELECT TOP 20 (PdtID) FROM AN_Product ORDER by PdtID )))
ORDER BY PdtID


服务器: 消息 170，级别 15，状态 1，行 4
第 4 行: ')' 附近有语法错误。

[allright_flash]

SELECT TOP 10 * FROM AN_Product
WHERE
(PdtID >
(SELECT MAX(PdtID) FROM (SELECT TOP 20 (PdtID)) FROM AN_Product ORDER by PdtID ))
ORDER BY PdtID
试试看！

[rookie_one]

SELECT TOP 10 * FROM AN_Product
WHERE
PdtID >
(SELECT MAX(PdtID) FROM (SELECT TOP 20 PdtID FROM AN_Product ORDER by PdtID ) t)
ORDER BY PdtID

[chuifengde]

SELECT TOP 10 * FROM AN_Product
WHERE
(PdtID >
(SELECT MAX(PdtID) FROM (SELECT TOP 20 (PdtID) FROM AN_Product ORDER by PdtID ) A))
ORDER BY PdtID

[hqbj08]

allright_flash()
SELECT TOP 10 * FROM AN_Product
WHERE
(PdtID >
(SELECT MAX(PdtID) FROM (SELECT TOP 20 (PdtID) FROM AN_Product ORDER by PdtID )))
ORDER BY PdtID
服务器: 消息 156，级别 15，状态 1，行 4
在关键字 'FROM' 附近有语法错误。

[hqbj08]

我马上给你们加分

[li95415667]

给子查询的结果取个别名就可以啦.