A function that partitions a result set and computes something within that partition without rolling up the data in that partition.
0
votes
1answer
25 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. ...
