Re: SQL question.

From: Thava Arumugam <tarumuga_at_online.no>
Date: Wed, 30 Jun 1999 14:00:16 +0200
Message-ID: <BFne3.174$Gx.670@news1.online.no>

If I understand correctly, you can use the following sql statement:

select name,max(date)
from <table>
group by name

Brgds
Thava

tan <tunrog_at_yahoo.com> wrote in message news:7l407s$c2d$1_at_nnrp1.deja.com...
> I have a simple question, suppose I have a table below:
>
> NAME RENTED DATE
>
> Bob A 03/29/98
> Bob A 05/19/99
> Joe D 12/19/98
> Barb E 03/09/99
> Barb C 06/19/99
> Barb E 09/05/98
>
>
> How do I just retrieve the most recent rows (by date)
> for each person? Thanks.
>
> ie.
> NAME RENTED DATE
>
> Bob A 05/19/99
> Joe D 12/19/98
> Barb C 06/19/99
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Jun 30 1999 - 07:00:16 CDT