Posted by listerofsmeg01 on 09/27/05 13:40

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).

Thanks,
Lister

[Back to original message]