RE: Query help with grouping and latest date.

2004-05-20 Thread emierzwa
grouping and latest date. On Thursday 20 May 2004 12:49, Egor Egorov might have typed: > Duncan Hill <[EMAIL PROTECTED]> wrote: > > I have a table that has data that looks like: > > ++-+---+-+ > > > > | id | recd

Re: Query help with grouping and latest date.

2004-05-20 Thread Duncan Hill
On Thursday 20 May 2004 12:49, Egor Egorov might have typed: > Duncan Hill <[EMAIL PROTECTED]> wrote: > > I have a table that has data that looks like: > > ++-+---+-+ > > > > | id | recdate | mount | perused | > > > > ++-+-

Re: Query help with grouping and latest date.

2004-05-20 Thread Egor Egorov
Egor Egorov <[EMAIL PROTECTED]> wrote: > Duncan Hill <[EMAIL PROTECTED]> wrote: >> I have a table that has data that looks like: >> ++-+---+-+ >> | id | recdate | mount | perused | >> ++-+---+-+ >> | 1 | 2004-05-20

Re: Query help with grouping and latest date.

2004-05-20 Thread Egor Egorov
Duncan Hill <[EMAIL PROTECTED]> wrote: > I have a table that has data that looks like: > ++-+---+-+ > | id | recdate | mount | perused | > ++-+---+-+ > | 1 | 2004-05-20 10:46:12 | QUAR | 80 | > | 2 | 2004-05

Query help with grouping and latest date.

2004-05-20 Thread Duncan Hill
I have a table that has data that looks like: ++-+---+-+ | id | recdate | mount | perused | ++-+---+-+ | 1 | 2004-05-20 10:46:12 | QUAR | 80 | | 2 | 2004-05-20 11:05:11 | QUAR | 99 | | 2 | 2004-05-20