lostformars posted 2 Years ago
My solution was very similar to another submitted solution. However, I really prefer CTEs over sub queries. Another benefit is Oracle's sub query factoring (not in use here), which will usually be more efficient (but not always!)....