I would suggest you look at window functions, because typically they let you do the same thing in a much cleaner manner- but I always need a few experiments on real data to get them right.