SELECT Based on Max() value 1

[tekdudedude]

Hello,

In an Oracle 10g database I have the below SQL which works:

SELECT sid,recid,stamp,output
FROM v$rman_output
WHERE recid > 17400
ORDER BY recid;

Functionally I need to run this:

SELECT sid,recid,stamp,output
FROM v$rman_output
WHERE recid > max(rownum)-25
ORDER BY recid;

But I get the error:

WHERE recid > max(rownum)-25
*
ERROR at line 3:
ORA-00934: group function is not allowed here


What can you recommend please?

Thanks,

TD

 

[r937]

SELECT sid
     , recid
     , stamp
     , output
  FROM v$rman_output AS T
 WHERE ( select count(*)
           from games
          where score < T.score ) < 25
ORDER 
    BY recid;

r937.com | rudy.ca

 

[tekdudedude]

r937,

Thanks for posting - that did the trick.

TD