To do this in MS SQL Server, add the following to the beginning of your column selection: ROW_NUMBER() OVER( ORDER BY b.Id) as NID which alters the example view to: SELECT ROW_NUMBER() OVER( ORDER ...

SELECT options refine results As we saw in the last article, the SQL SELECT statement has the ... You can also use it to count the number of rows in any result set. SELECT COUNT(*) FROM Sales ...