A function that partitions a result set and computes something within that partition without rolling up the data in that partition.

learn more… | top users | synonyms

1
vote
1answer
112 views

Filter on a window function without writing an outer SELECT statement

Since window functions cannot be included in the WHERE clause of the inner SELECT, is there another method that could be used to write this query without the outer SELECT statement? I'm using Oracle. ...