|
|
Posted by The Natural Philosopher on 10/08/07 08:43
Jerry Stuckle wrote:
> The Natural Philosopher wrote:
>> Jerry Stuckle wrote:
>>> The Natural Philosopher wrote:
>>>> Rik Wasmus wrote:
>>>>> On Sun, 07 Oct 2007 00:20:12 +0200, Shelly
>>>>> <sheldonlg@asap-consult.com> wrote:
>>>>>> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
>>>>>> news:QI6dnSmjxJezY5ranZ2dnUVZ_v_inZ2d@comcast.com...
>>>>>>> Colleen wrote:
>>>>>>>> I'm trying to find out if there's a query/function similar to
>>>>>>>> the RANK
>>>>>>>> function in Excel.
>>>>>>>> What I want to be able to do is take a list of dates from a
>>>>>>>> particular
>>>>>>>> table field, and be able to rank each record in the order within
>>>>>>>> which
>>>>>>>> in falls in those range of dates, because records are not always
>>>>>>>> entered in chronological order.
>>>>>>>> So, from this "ranking" query (that would generate the result
>>>>>>>> $rank),
>>>>>>>> I want to be able to say:
>>>>>>>> echo "$casualtyID is the number $rank casualty to die in the
>>>>>>>> current
>>>>>>>
>>>>>>> Next time, please post your SQL questions to a MySQL newsgroup.
>>>>>>
>>>>>> This was actually both an SQL and a php question.
>>>>>>
>>>>>
>>>>> Euhm, how is PHP involved again?
>>>> Well it could have been: You could have done the sorting in php
>>>> instead of MySQL.
>>>
>>> And why reinvent the wheel?
>>>
>> Because you didn't know there was a wheel already invented?
>> Because it is made out of materials you don't have to hand?
>> Because you LIKE inventing wheels?
>> Because none of the wheels immediatetly to hand fit your wagon?
>>
>> I could go on..
>
> IOW, because you're stoopid?
>
> I don't have a problem with the op asking the question here. But it
> would have been much better to let them know that this is easily handled
> in SQL, and point them to the appropriate SQL newsgroup.
>
> But some people just don't get it. They think a newsgroup is their own
> personal playground and the newsgroup charter doesn't apply to them.
>
>
That sounds like you allright.
>
Navigation:
[Reply to this message]
|