谁帮我把这句sql语名进行降序排列?

来源:百度知道 编辑:UC知道 时间:2024/05/09 19:56:57
select a.Articleid,a.title,b.channelDir from PE_Article a,PE_channel b where a.channelid = b.channelid and a.title like '%"&key&"%'

看你按照哪个字段降序排列
如按照a.Articleid降序排列,则:
select a.Articleid,a.title,b.channelDir from PE_Article a,PE_channel b where a.channelid = b.channelid and a.title like '%"&key&"%' order by a.Articleid desc

也就是说按照哪个字段降序排列,则order by 某字段 desc

在语句的后面加上order by desc