急急急！求大神！排序 同organ_id、同user_id 的数据 只取一条

Question

本帖最后由 u010001857 于 2014-02-24 12:20:00 编辑

Answer 1

分析函数：select *
  from (select t.rwrq,
               u.user_id,
               u.user_name,
               u.organ_id,
               u.MOBILE_PHONE,
               row_number() over(partition by u.organ_id, u.user_id order by u.organ_id, u.user_id) rnn
          from GYKQDJ t
          left join (select t1.user_id      user_id,
                           t1.organ_id     organ_id,
                           t1.MOBILE_PHONE MOBILE_PHONE,
                           t1.user_name    user_name
                      from s_user_list t1, s_user_role t2
                     where t1.user_id = t2.user_id
                       and t2.role_id = '202') u
            on t.jgm = u.organ_id
         where t.flag = '2'
           and to_char(sysdate, 'yyyymmdd') = rwrq) n
 where n.rnn = 1

Answer 2

请看
http://bbs.csdn.net/topics/390714615