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
>

• Next in forum: isqlw won't start
• Prev in forum: Re: find unique identifier through multiple tables
• Thread view: Re: a small SQL Puzzle

[Reply to this message]