how to generate index number or serial number in select statement

party_code_table

ID	Code
43224	R06048
42335	J06600
42324	M06791

I want a select statement to get data like this:

SL	Code
1	R06048
2	J06600
3	M06791

 

SELECT ROW_NUMBER() OVER (ORDER BY CODE) AS SL, Code
FROM party_code_table

ORDER BY CODE