这句SQL语错在哪
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
