Posted by listerofsmeg01 on 09/28/05 12:07

Stefan Rybacki wrote:
> Its easy in your special case. Just count the entries with newer or older dates and you
> know the position.
>
> for older:
>
> SELECT count(*) FROM table WHERE date<(SELECT date FROM table WHERE name="someone")
>
> for newer:
>
> SELECT count(*) FROM table WHERE date>(SELECT date FROM table WHERE name="someone")
>
>
> Regards
> Stefan

Thanks a million. It's obvious now you've shown me! Durr.

Thanks for everyone else's replies too, although I think some of you
got the wrong end of the stick in what I wanted. I want a position
given a name, not a name given a position.

Thanks again,
Lister

• Next in forum: Re: Newbie - finding ordered position
• Prev in forum: BCC mail function
• Thread view: Re: Newbie - finding ordered position

[Reply to this message]