You cannot use an Order by in an Update statement
therefore you can't
UPDATE ROB/ALAN
SET RANKING=0
ORDER BY BUCKS

Then I can't think of any built in function which would return the number
you desired.

My question is this, what possible value is a ranking number when you can
organize the file by any sort criteria you wish?  Especially when you've
already determined that the rank is based on another column.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    "Alan Novick"
                    <mida@pressmantoy.c       To:     "MidRange-L" 
<MidRange-L@MidRange.Com>
                    om>                       cc:
                    Sent by:                  Fax to:
                    midrange-l-admin@mi       Subject:     Can you do this in 
SQL
                    drange.com


                    01/29/2002 01:45 PM
                    Please respond to
                    midrange-l






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

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.







As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.