我可以执行这个。
我必须执行以下操作。为什么上述方法行不通?
SELECT TOP 10 model, price
FROM PC
EXCEPT
SELECT TOP 9 model, price
FROM PC ORDER BY price DESC
但是当我运行这个程序时,我收到了“Order”附近的语法错误。
SELECT TOP 10 model, price
FROM PC ORDER BY price DESC
EXCEPT
SELECT TOP 9 model, price
FROM PC ORDER BY price DESC
我必须执行以下操作。为什么上述方法行不通?
SELECT * FROM
(
SELECT TOP 10 model, price
FROM PC ORDER BY price DESC
EXCEPT
SELECT TOP 9 model, price
FROM PC ORDER BY price DESC
) X