Access Previous Row Value and Next Row Value

(Hannes du Preez) There are times that you need to access information from the previous row or next row from the current row. Here is a small trick that makes use of a CTE to get this information:

Register to Read