Re: Select / Group by

[Ben Petersen]

On 17 Aug 2001, at 18:27, Bill Downall wrote:

> Ben,
> 
> It's too bad you didn't use a DATETIME datatype. then a single column 
> can be used to find the latest.  With two columns, it's a lot more 
> complicated

The data comes from a third party so I don't have much say in the 
design.

> However, if your TransNum is a numerical sequence in chronological 
> order, it's easy:

>From what I can see this is true,  but is not part of the specs 
provided.  I'd be concerned to assume that I could rely on it.


Thanks,

Ben