GROUP BY和ORDER BY共用 

SELECT BatchNumber,MAX(Id) FROM dbo.SceneryOrder
WHERE RowStatus=1 AND BatchNumber<>'' 
GROUP BY BatchNumber
ORDER BY 2 DESC

 

posted @ 2014-01-06 13:01  apegu  阅读(906)  评论(0)  编辑  收藏  举报