Click here to Skip to main content
15,891,864 members
Articles / Programming Languages / SQL

How to Fetch Data from the Previous or Next Rows in the Resultset

Rate me:
Please Sign up or sign in to vote.
4.82/5 (6 votes)
26 Jul 2015CPOL2 min read 25.5K   3  
This tip demonstrates the use of LAG and LEAD functions in Oracle.

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect
Europe Europe
Biography provided

Comments and Discussions