Posted by Michael Gray on 07/08/05 12:12

On 8 Jul 2005 01:10:47 -0700, throat.wobbler.mangrove@gmail.com wrote:

>One final thing...I have tried GROUPING BY all of the fields in s (in
>the wider expression), but if I have a record with identical
>RCRD_REFNOs and max MODIF_DTTM's, but one of the other fields differs,
>then I get two records for that unique ID...which brings me back once
>again to the TOP 1 thing...I'm now stuck!

Have a look at "Using DISTINCT with Aggregate Functions" in the SQL
bol, and see if this will help.

[Back to original message]