Tested on: SQL Server 2016 Developer Edition Accurate as of: January, 2018 In this query, I've added a record number column to the result set using OVER and ORDER BY clauses with the ROW_NUMBER function in T-SQL. Note that the ORDER BY clause is required. The OVER() clause tells the SQL Engine to sort data … Continue reading Show ROW NUMBERS in T-SQL RESULT set