select *,COUNT(*) over() '全班人數' from   Student 

  select *,COUNT(*) over(partition by Ssex) '性別人數' from   Student  --over()中加入partition by Ssex表示 按Ssex字段分組 男女分別為4人。

 select *,ROW_NUMBER() over(order by year(sage)) 'rownumber行號',           RANK() over(order by year(sage)) 'rank有并列而且會出現斷號',          dense_rank() over (order by year(sage)) 'dense_rank密集排名',          NTILE(4) over(order by year(sage)) '分組排名' from  Student 

  select *,ROW_NUMBER() over(partition by year(sage)  order by year(sage)) 'rownumber行號'  ,                  RANK() over( partition by year(sage) order by year(sage)) 'rank有并列而且會出現斷號'    ,                  dense_rank() over ( partition by year(sage) order by year(sage)) 'dense_rank密集排名',                    NTILE(4) over(partition by  year(sage) order by year(sage)) '分組排名'from  Student 

  select top 3 with ties  * from Student order by year(sage) --只取前3行，如果最后第3行中sage的年份和后面的年份相同，則附加隨后的行