The ROW_NUMBER example is great - I've been asked this in interviews before!