2015年5月7日
rank() | dense_rank() | row_number() over(PARTITION BY sex order by age desc ) 的区别
摘要： 1、row_num() over()函数：根据某个字段排序后编号1,2,3。。select *,ROW_NUMBER() over ( order by majorid) as numfrom StudentInfo s2、rank() over(PARTITION BY 字段A order by... 阅读全文
posted @ 2015-05-07 10:44 谷樵 阅读(215) 评论(0) 推荐(0) 编辑