[MSSQL]SQL SERVER 2005-OVER (PARTITION BY…)的用法

按字段进行排序 比如： 编号      InfoId,      SeriesId,  11           a         class_1  22           b         class_1  33           c         class_1  44           d         class_2  55           e         class_2  66           f         class_2  ...          ...         ... ----------------------------- 查询出来结果是这样 11       a       class_1    1 22       b       class_1    2 33       c       class_1    3 44       d       class_2    1 55       e       class_2    2 66       f       class_2    3 --------------------------------------------------------------- Select InfoId, SeriesId, ROW_NUMBER() OVER(PARTITION BY SeriesId ORDER BY InfoId) AS ord FROM [uc_QuotePrice] WITH (NOLOCK) ORDER BY SeriesId,ord ---------------------------------------------------

OVER (PARTITION BY…)的用法 OVER (PARTITION BY…) 按照某列分割/区分

SELECT EMP.*,SUM(SAL) OVER(P