|
|
Posted by Stefan Rybacki on 09/27/05 15:29
Hilarion wrote:
> listerofsmeg01@hotmail.com wrote:
>
>> OK, I have tried reading the manual on this one, but I cannot work it
>> out. Probly easy for a SQL veteran...
>>
>> I need to get the position (ie 3rd from top - 3) of a particular record
>> FROM AN ORDERED RESULT SET.
>>
>> In other words, I need to do something like:
>> SELECT "position or whatever the magic word is" from (SELECT * FROM
>> MyTable ORDER BY Date) where Name = "someone";
>>
>> So given "someone", I want to find out how recent their entry is (eg
>> 3rd most recent).
>
>
>
> In MySQL you could use LIMIT clause like this:
>
> SELECT *
> FROM mytable
> WHERE name = 'someone'
> ORDER BY mydate
> LIMIT 2, 1
>
>
Hilarion you got him/her wrong. He wants to get the postion (in the example 3) itself.
Regards
Stefan
> which will return third "someone" (in "myate" order). (Do not use "date"
> as column name because it is a reserverd keyword - name of type - in
> many SQL dialects and may cause problems.)
I do agree to this.
>...
>
> Hilarion
Navigation:
[Reply to this message]
|