Click here to Skip to main content
13,042,421 members (122,676 online)
Click here to Skip to main content
Articles » Database » Database » Oracle » Revisions


3 bookmarked
Posted 22 Feb 2011

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

, 26 Jul 2015
This tip demonstrates the use of LAG and LEAD functions in Oracle.



Compare Revision Minor Date Status Editor
5 - publicly available Yes 26-Jul-15 10:41 Available Deeksha Shenoy
Initial creation
4 No 26-Jul-15 9:08 Available Wendelius
Subsection changed
3 No 29-Jul-11 10:59 Available Wendelius
1 No 22-Feb-11 12:29 Composing Wendelius


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


About the Author

Finland Finland
No Biography provided

You may also be interested in...

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170713.1 | Last Updated 26 Jul 2015
Article Copyright 2011 by Wendelius
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid