Row Numbers in result set

[ales]

Hi,

select CustID, Amount, rownum as row_id from (Select CustID, Sum(Amount) as Amount From MyTable Group by CustId)

Do not confuse rownum and rowid. Rowid has special meaning in Oracle.