随笔分类 -  oracle

oracle 分组排序
摘要：SELECT * FROM (SELECT A.*, RANK() OVER(PARTITION BY A.DR_ATP_ID, A.AT_CODE ORDER BY A.KEY_CODE) RANK FROM DR_ATP... 阅读全文
posted @ 2015-04-10 11:18 鱼香茄子 阅读(925) 评论(0) 推荐(0)