Sql PARTITION BY 

 SELECT t2.* ,
        t2.RowNumber
 FROM   ( SELECT    row_number() OVER ( PARTITION BY t.PartitionColumn ORDER BY t.ID DESC ) RowNumber ,
                    t.*
          FROM      Table t
        ) t2
--WHERE   t2.RowNumber = 1
ORDER BY t2.RowNumber ASC

 

posted @ 2015-01-18 22:14  astrue  阅读(520)  评论(0)  编辑  收藏  举报