Posted by Fiori on 09/27/07 06:06

Thank you.

Roy Harvey (SQL Server MVP) schreef:
> Unless there are twins who are both the oldest this will do what you
> ask.
>
> SELECT *
> FROM SomeTable as A
> WHERE birthdate =
> (SELECT MIN(birthdate)
> FROM SomeTable as B
> WHERE A.address = B.address)
>
> Roy Harvey
> Beacon Falls, CT
>

[Back to original message]