i have this SQL
it produces output like below
With SQL Server 2014 you are on the lucky side. There is
Add this to your last select
SELECT * ,LEAD(ALPHA) OVER(ORDER BY (SELECT NULL)) AS NextAlpha FROM T AS T1
And be aware, that the
ORDER BY (SELECT NULL) would work with this kind of query only, you should rather use a decent sort criterium.