select-Adding an ordinal column (SQL Server)

SELECTrow_number () Over(ORDER  byActual payment amount) asA--Serial NumberRank () Over(ORDER  byActual payment amount) asB--the same count one, skip the new calculationDense_rank () Over(ORDER  byActual payment amount) asC--the same count one, do not skip the new calculationNTILE (4) Over(ORDER  byActual contribution Amountdesc) asD--GROUP by given number of numbersActual contribution Amount from [dbo].[a flow fee summary]ORDER  byActual contribution Amount

Learning Address:

        Http://www.cnblogs.com/cailinaaa/archive/2006/10/20/534988.aspx

        http://blog.csdn.net/liu_1983/article/details/7269312

select-Adding an ordinal column (SQL Server)