Posted by Fiori on 09/26/07 18:37

Hi,

Probable there is a simple solution for this, hopefully someone can
direct me in the right direction.

I have a table with a persons firstname, lastname, birthdate and
address. However, I want to select only one person per address, namely
the eldest of all persons living on the same address.

Can anyone provide me a solution?

Thanks in advance.
Duncan

• Next in forum: Re: a small SQL Puzzle
• Prev in forum: Re: How do I view table information such as constraints?
• Thread view: a small SQL Puzzle

[Reply to this message]