Re: Can you do this in SQL

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Alan,

Not directly, I would look at a separate ranking file maintained
in a trigger.

David Morris

>>> mida@pressmantoy.com 01/29/02 11:45AM >>>
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