insert 语句的order by是没有意义的INSERT INTO JSTJB
(caller, month, times, totaltime) select * from (SELECT caller, MONTH(starttime) AS month, COUNT(caller) AS times, SUM(DATEDIFF(second, starttime, endtime)) AS sumtime
FROM MRHDTJ
GROUP BY caller, MONTH(starttime)
ORDER BY caller
) as x
(caller, month, times, totaltime) select * from (SELECT caller, MONTH(starttime) AS month, COUNT(caller) AS times, SUM(DATEDIFF(second, starttime, endtime)) AS sumtime
FROM MRHDTJ
GROUP BY caller, MONTH(starttime)
ORDER BY caller
) as x
除非同时指定了 TOP,否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。
还是不行呀