select right from (select row_number() over (order by RIGHTLEVEL desc) num ,RIGHT from table where URL like 'http://www.java%') where num=1
吼吼~ 刚在数据库上测试过~如果是想取出权限最大,下面的语句是正确滴~SELECT right FROM ( SELECT RIGHT FROM policyres WHERE URL LIKE 'http://www.java* ORDER BY right DESC) WHERE ROWNUM =1
select right from policyres where rightlevel = (select max(RIGHTLEVEL) r from policyres where URL like 'http://www.java*');
SELECT * FROM policyres a, (SELECT MAX (rightlevel), ROWNUM AS row1 FROM policyres WHERE url LIKE 'http://www.java*' group by rownum) b where a.rownum = b.rownum
from
(select row_number() over (order by RIGHTLEVEL desc) num ,RIGHT
from table
where URL like 'http://www.java%')
where num=1
刚在数据库上测试过~如果是想取出权限最大,下面的语句是正确滴~SELECT right FROM (
SELECT RIGHT FROM policyres WHERE URL LIKE 'http://www.java*
ORDER BY right DESC)
WHERE ROWNUM =1
http://www.chinaunix.net 3 allow
你的语句就会错
FROM policyres a, (SELECT MAX (rightlevel), ROWNUM AS row1
FROM policyres
WHERE url LIKE 'http://www.java*' group by rownum) b
where a.rownum = b.rownum