Re: Can you do this in SQL

["Alan Novick" <mida@xxxxxxxxxxxxxxx>]

Well actually Rob I simplified the file for the excercise.  I'll also have a
year field and then I can see who was number what in each year, that is the
real need for the rank field.  I can and will easily do this in RPG but just
wondered if there was an SQL function.

----- Original Message -----
From: <rob@dekko.com>
To: <midrange-l@midrange.com>
Sent: Tuesday, January 29, 2002 2:25 PM
Subject: Re: Can you do this in SQL



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.





_______________________________________________
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.