group by 与 partitionby的区别
一、首先创建一个表
CREATE TABLE [dbo].[tb_Student](
[ID] [int] NOTNULL,
[stuName][nvarchar](50) NOT NULL,
[grade] [int] NOTNULL,
[age] [int] NOTNULL,
[classID] [int] NOTNULL,
)