ROW_NUMBER()

SELECT product, amount, ROW_NUMBER() OVER (ORDER BY amount DESC) AS rn FROM dbo.orders;

product                                  amount       rn
---------------------------------------- ------------ --------------------
monitor                                        438.00                    1
monitor                                        219.00                    2
keyboard                                        99.00                    3
keyboard                                        49.50                    4
mouse                                           27.75                    5
cable                                           15.00                    6

SELECT 
  name, recovery_model_desc
FROM sys.databases 
WHERE database_id < 5
ORDER BY name ASC;

master|SIMPLE
model|FULL
msdb|SIMPLE
tempdb|SIMPLE

SELECT 
  ROW_NUMBER() OVER(ORDER BY name ASC) AS Row#,
  name, recovery_model_desc
FROM sys.databases 
WHERE database_id < 5;

1|master|SIMPLE
2|model|FULL
3|msdb|SIMPLE
4|tempdb|SIMPLE