Wednesday, 28 August 2013

Oracle - calculate number of rows before some condition is applied

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