--//*****************************************//
ROW_NUMBER() OVER(PARTITION BY t.aaa027 ORDER BY t.weight,t.AAB004 NULLS LAST)
语法:在分组函数中,根据分组(给各个分组都从1开始的编号)取一个分组的各自100行
ROW_NUMBER() OVER(PARTITION BY t.aaa027 ORDER BY t.weight,t.AAB004 NULLS LAST)
语法:在分组函数中,根据分组(给各个分组都从1开始的编号)取一个分组的各自100行