Window functions

[MarkMpn]

SELECT leadid, ROW_NUMBER() OVER (PARTITION BY parentaccountid ORDER BY createdon ASC) AS rownum
FROM lead
WHERE parentaccountid IS NOT NULL