This email was created by [your name] who thought you would be interested in the following Article:
"How to fetch data from the previous or next rows in the resultset"
This tip demonstrates the use of LAG and LEAD functions in Oracle.
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!