摘要：
select rgv.GROUP_ID ,rgv.GROUP_NAME ,rgv.RELATED_GROUP_ID,rgv.RELATED_GROUP_NAMEfrom( select row_number() over(PARTITION BY GROUP_ID ORDER BY fSign desc ) rn ,rg.* from( SELECT B.GROUP_RELATE_ID, B.GROUP_ID, A.GROUP_NAME, B.RELATED_GROUP_ID, C.GROUP_NUMBER RELATED_GROUP_NUMBER, C.GROUP_NAME RELATED_ 阅读全文
posted @ 2012-06-21 15:10 奥客 阅读(421) 评论(0) 推荐(0) 编辑