SELECT MAX(id) FROM (SELECT TOP 25 id FROM xx_table ORDER BY addtime DESC)
------解决方案--------------------------------------------------------
SELECT MAX(id) FROM (SELECT TOP 25 id FROM xx_table ORDER BY addtime DESC) a
加个别名
------解决方案--------------------------------------------------------
视图内不能 order by
------解决方案--------------------------------------------------------
另外还要加别名.
------解决方案--------------------------------------------------------
SELECT MAX(id) FROM (SELECT TOP 25 id FROM xx_table ORDER BY addtime DESC) as t
------解决方案--------------------------------------------------------
SELECT MAX(id) FROM (SELECT TOP 25 id FROM xx_table ORDER BY addtime DESC)t
------解决方案--------------------------------------------------------
SELECT MAX(id) FROM xx_table
WHERE id in(SELECT TOP 25 id FROM xx_table ORDER BY addtime DESC)
------解决方案--------------------------------------------------------
up
------解决方案--------------------------------------------------------
with table as
(
select id Rank() over(order by addtime Desc) rank from XX_table
)
select max(id) from tagle where rank <25
------解决方案--------------------------------------------------------
SELECT MAX(id) FROM (SELECT TOP 25 id FROM xx_table ORDER BY addtime DESC) as z
这个错误我犯过！！！
------解决方案--------------------------------------------------------
+ AS TableName