Can you do this in SQL

["Alan Novick" <mida@xxxxxxxxxxxxxxx>]

Lets say I have a file with three fields, customer number, dollars sold, and
rank.  I can fill the customer number and dollars sold fields from my files.
I then one to put a number in the rank field, so that the customer who
bought the most gets a ranking of one, the one who bought less gets 2, etc.
Is there a way to do this in sql?

Thanks,

Alan Novick
Pressman Toy Corporation
New Brunswick, NJ