sql;">-- 開窗函數(shù)：在結(jié)果集的基礎(chǔ)上進(jìn)一步處理(聚合操作)-- Over函數(shù),添加一個字段顯示最大年齡SELECT * ,    MAX(StuAge) OVER ( ) MaxStuAgeFROM  dbo.Student;-- Over函數(shù),添加一個字段顯示總?cè)藬?shù)SELECT * ,    COUNT(StuID) OVER ( ) StuCountFROM  dbo.Student;-- Partition By 分組統(tǒng)計數(shù)量-- 根據(jù)性別分組后，統(tǒng)計SELECT COUNT(*) OVER ( PARTITION  BY StuSex ) ,    *FROM  dbo.Student;-- 根據(jù)班級分組后，統(tǒng)計、排序SELECT COUNT(*) OVER ( PARTITION  BY Class ORDER BY Height) ,    *FROM  dbo.Student;-- Over函數(shù),添加一個字段顯示平均身高SELECT * ,    AVG(Height) OVER ( ) AgeHeightFROM  dbo.Student;--Row_Rumber()SELECT ROW_NUMBER() OVER ( ORDER BY StuID DESC ) RowNumber ,    *FROM  dbo.Student--Row_Rumber() 實現(xiàn)分頁效果;WITH  T AS ( SELECT  ROW_NUMBER() OVER ( ORDER BY StuID DESC ) RowNumber ,            *        FROM   dbo.Student       )  SELECT *  FROM  T  WHERE  T.RowNumber BETWEEN 1 AND 3;--Rank() 排名函數(shù),名次相同，跳過SELECT RANK() OVER ( ORDER BY Height ) ,    *FROM  dbo.Student;--DENSE_Rank() 排名函數(shù)，名次相同不跳過SELECT DENSE_RANK() OVER ( ORDER BY Height ) ,    *FROM  dbo.Student;-- NTILE()函數(shù)，參數(shù)：記錄總數(shù)/劃分區(qū)域 = 每個區(qū)域數(shù)組，把記錄序號放進(jìn)數(shù)組 (平均分組)SELECT NTILE(3) OVER ( ORDER BY StuSex ) ,    *FROM  dbo.Student;