|
|
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
Navigation:
[Reply to this message]
|