求助大神看看这段SQL语句的错误 提示关键字 'order' 附近有语法错误。

Question

select top 50 * from (select top 50 ID,* from TYPE_221 where keyContent like '%test%' order by ID DESC) order by ID ASC
我使用的是SQL2005

Answer 1

写的好乱，两次排序可以去掉一次。两个top 50只用一个就可以。

select *
from (
select top 50 *
from TYPE_221
where keyContent like '%test%'
order by ID DESC
)
order by ID ASC

----第二种改法
select *
from (
select top 50 *
from TYPE_221
where keyContent like '%test%'
)
order by ID ASC

----这个应该是你要的结果排序吧
select top 50 *
from TYPE_221
where keyContent like '%test%'
order by ID ASC

Answer 2

给外面那层加个别名试试

追问

加了也一样,原本是ACCESS数据库我转SQL了.