I have a report that show all of are salesmen sorted by the number of sales they have. What I have been asked to do is to give them an actual ranking (Number 1, Number 2 etc...). Being fairly new to SQL I am not sure how to do this so here I am.
Thank you for any help that anyone can give me.
You can use RowNumber(Nothing). Check out the docs for more info.
|||Thank you for the help.
No comments:
Post a Comment