|
|
Posted by Jerry Stuckle on 10/08/07 12:05
The Natural Philosopher wrote:
> 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.
>
>
>>
No, assholes and trolls don't get it. And you're both.
You could read the charter for this newsgroup. And understand the
purpose for which it was approved to be created.
But that's assuming you can read, which we know you can't. And that you
can understand simple language, which we know you can't either.
But you do think this is your own personal playground.
Hell, you've even admitted you aren't a programmer. So why do you
bother hanging around except to stroke your ego?
At least some people here actually help others with on-topic questions.
I have yet to see you do anything useful.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|