select RegionID,RegionDescription,
lag(RegionDescription,1,0) over(order by RegionID) proceding_row,
lead(RegionDescription,1,0) over(order by RegionID) following_row
from [dbo].[Region]
Subscribe to:
Post Comments (Atom)
Big Data & NoSQL, Information Architecture, Data Management, Governance, etc. Focus on new technologies and performance tuning