Oracle - calculate number of rows before some condition is applied
I would like to know how many rows would be returned without rownum
condition in a given query:
SELECT columns
, [number of rows before applying rownum] AS numberofrows
FROM tables
WHERE conditions
AND rownum < 100
Is it possible without using a subquery?
No comments:
Post a Comment