asp问题,高手帮个忙!!!

来源：百度知道 编辑：UC知道 时间：2024/06/20 06:17:33
"select top 3 * from post where addboard_id = " & rsc("id")这句倒序的写法怎么写??
也就是怎么把"order by id desc"加进去!!我开始这样"select top 3 * from post where addboard_id = " & rsc("id") & "order by id desc"加了,语法错误!!!请高手指教正确的写法!!!谢谢!!!

"select top 3 * from post where addboard_id ="&rsc("id")&" order by id desc"

你少个空格

倒序？？ 如何倒 是先从最后一个取吗？

select top 3 from post where addboar_id = &rsc("id") order by desc

sql = "SELECT TOP 3 FROM POST WHERE addboard_id = " & rsc("id") & " ORDER BY ID DESC"

"order by id desc"
" ORDER BY id DESC"
区别

真晕，修改一下给ert211抢了位置