Let's say I have a table with the following fields. State, Customer,
and Total Sales. What I want to do is rank each customer by sales
volume by state. i.e. highest sales is ranked 1, second highest ranked
2, etc within each state.
I think I could do this in a cumbersome fashion by using the max
function, appending, deleting and using the max function again for #2
and so on. I was wondering if there is a built in function or a piece
of code or expression that would assign these rankings automatically in
a new field.
Which brings me to this. I guess I need to learn SQL. Are there any
web resources or books that anyone can recommend? Thanks
max