sqlserver排序selecttop3ui.username,u.titles,u.[date],u.platefromBigPlatebleftjoinlittleplatelon(l.id=b.littleplateid)leftjoinUserbloguon(u.plate=l.id)leftjoinuserinfouion(ui.id=u.id)whereb.bigplate='KZ极限专区'orderby

Question

sqlserver排序
select top 3 ui.username,u.titles,u.[date],u.plate from BigPlate b left join littleplate l on(l.id=b.littleplateid)
left join Userblog u on(u.plate=l.id)
left join userinfo ui on(ui.id=u.id)
where b.bigplate = 'KZ极限专区' order by u.[date] desc
我想在这句sql的查询结果的基础上再order by u.plate asc
应该怎么写啊?

Answer 1

select top 3 ui.username,u.titles,u.[date],u.plate from BigPlate b left join littleplate l on(l.id=b.littleplateid)
left join Userblog u on(u.plate=l.id)
left join userinfo ui on(ui.id=u.id)
where b.bigplate = 'KZ极限专区' order by u.[date] desc,u.plate asc

直接加就行了吧,主排序放前边,次排序放后边,弄对顺序就好