Question

sql 选择倒二条记录（消息 156，级别 15，状态 1，第 1 行 关键字 'order' 附近有语法错误）为什么？

代码是：select top 1 * from ( SELECT top 2 dapeiContent FROM dapeiArticle where dapeiLeiBie= '颜色搭配' order by ID desc ) order by ID

Answer 1

select top 1 * from ( SELECT top 2 ID,dapeiContent FROM dapeiArticle where dapeiLeiBie= '颜色搭配' order by ID desc )a order by a.ID ,建清告议你系统化学习一下数据迟正旅库的查询码凳；

Answer 2

子查陵行清询加尺前一个带困别名：
select top 1 * from ( SELECT top 2 dapeiContent FROM dapeiArticle where dapeiLeiBie= '颜色搭配' order by ID desc ) a order by ID