select top 10 * from (select * from PL_REPORT_DATA order by publish_time desc) as t1
看上去没问题 会报错
改为:
select top 1 * from (select TOP 100 PERCENT * from PL_REPORT_DATA order by publish_time desc) as t1
除非另外还指定了 TOP 或 FOR XML,否则,ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。
最新推荐文章于 2024-02-20 09:43:53 发布