Nice easy question, thanks Jeff
However, there appears to be an inaccuracy in the answer, viz:
if a PARTITION BY clause is used there is no comma between the PARTITION BY and OVER clause
i believe should read:
if a PARTITION BY clause is used there is no comma between the PARTITION BY and ORDER BY clauses
Nice catch Stewart. Looks like once the question is posted I can no longer edit. So maybe some super admin on this site can update that.