select出的sum能查出来,但一直提示Order by clause 不能使用此查询类型
蝈蝈俊 2000-04-11 10:27:00 (在sql server的views中的new views中)
sql语句:
SELECT *
FROM (SELECT companyid, SUM(point) AS cc
FROM Tproduct
GROUP BY companyid
HAVING companyid IN
(SELECT companyid
FROM Tsellcompany
WHERE agreement = '1')) a
ORDER BY cc DESC
提示
Order by clause 不能使用此查询类型
结果能出现,
在asp语句中无法运行。