Oracle去重

按usercode去重

select u.usercode userCode, min(u.usertext) userText
          from sy_user u
         where u.sitecode = 10000
         group by u.usercode
         order by u.usercode

Oracle去重

标签：sql   site   user   from   去重   rac   order by   group   log