|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.