新时代的IT人

摘要： 今天遇到一个问题：Code：select row_no, roleid, roleName from (select roleid, roleName, rank() over(order by sum(decode(roundrs, 1, 40, 2, 20, 3, -10, 0, 20, 0)) + 50 desc, sum(decode(roundrs, 1, 1, 0)) desc, sum(decode(roundrs, 3, 1, 0))) row_no from (select roleId, r... 阅读全文