group by 与 order by

group by 与 order by

USE [mydb] go WITH w AS( SELECT TOP 6 InfoId FROM( SELECT InfoId FROM( SELECT TOP 6 b.InfoId FROM dbo.[BrowseLog] b,dbo.[Info] i WHERE b.InfoId=i.InfoId AND i.CityId=3 GROUP BY b.InfoId ORDER BY MAX(b.BrowseId) DESC ) i1 UNION SELECT InfoId FROM( SELECT TOP 6 InfoId FROM dbo.[Info] WHERE CityId=3 ORDER BY InfoId DESC ) i2 ) u ORDER BY InfoId ASC ) SELECT w.InfoID ,i.[desc] ,i.small_pic_url ,s.SiteUrl ,s.SiteName FROM w,dbo.[Info] i,dbo.[Site] s WHERE w.InfoId=i.InfoId AND i.SiteId=s.SiteId ORDER BY w.InfoId DESC;

直接写 ORDER BY b.BrowseId

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。