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)
Database, Information Architecture, Data Management, etc. Focus on new technologies and performance tuning
No comments:
Post a Comment