23 1/10/2004 50
23 1/18/2004 60
23 2/11/2004 40
27 2/11/2004 35
27 2/24/2004 31
27 1/19/2004 13
Returns
23 2/11/2004 40
27 2/11/2004 35
27 2/24/2004 31
Mark's solution will work. If your db doesn't alow the syntax, you can
try to make a composite column of date and CN and filter on that
(convert both to char and append them, or something like that)
Pascal
> -----Original Message-----
> From: Andrew Tyrone [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 28 mei 2004 0:22
> To: CF-Talk
> Subject: RE: Return Most Recent Record PER CLIENT
>
> On the right track. This will remove the duplicates and
> should be ANSI
> compliant:
>
> SELECT DISTINCT
> cn,
> date,
> score
>
> FROM
> table
>
> WHERE
> date IN (
> SELECT MAX(date)
> FROM table
> GROUP BY cn
> )
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
