Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
CREATE TABLE #yt ([Store] int) ; INSERT INTO #yt ([Store]) VALUES (102), (101) ; SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS rownumber, Store FROM #yt ) AS foo WHERE rownumber =2