SQL Abfrage Nummerieren? Wie geht das?

[rwachtel]

SQL-Code:

select (select count(*) from PRODUCT as B where (B.PROD_ID <= A.PROD_ID)) as RANK, A.PROD_ID, A.NAME
from PRODUCT as A
order by PROD_ID