Click here to Skip to main content

Go to Tip/Trick

How to fetch data from the previous or next rows in the resultset

Wendelius

Rate me:

5.00/5 (4 votes)

31 Aug 2014CPOL1 min read

28.8K

11

This tip demonstrates the use of LAG and LEAD functions in SQL Server.

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

Wendelius

Architect

Europe

Biography provided

Comments and Discussions

Go to top