oracle分组排序查询

oracle分组排序查询

SELECT *
FROM
  (SELECT row_number() over(partition BY service_name order by service_id DESC) rn,
    bs.*
  FROM mct_business_service bs
  )
WHERE rn >1;