LEAD

Allows each record to access a record from the next record. The specified record is passed into the LAG method. On the lest record this value will be NULL, since there are no following records.

SELECT 
	ColName1,
	ColName2,
	ColName3,
	LEAD(ColName1) OVER (PARTITION BY ColName1 ORDER BY ColName1, ColName2) AS Lead
FROM SchemaName.TableName
	ORDER BY ColName1, ColName2

Note: using PARTITION BY ColName1 is optional