Have you tried this:
select ..., max(date) as mdate from ... where ... group by ... order
by mdate desc ?
I haven't tested it, but it should order the results by max date
descending, giving you the greatest date first.
On Fri, 10 Sep 2004 18:16:00 -0700, bruce <bedouglas@stripped> wrote:
> hi...
>
> i have the following select...
> select
> itemID,
> process,
> status,
> tblType,
> max(date)
> from historyTBL
> where (tblType = '3' or tblType = '2')
> group by tblType;
>
> it seems to work, in that it gives me the rows for the two types that i'm
> grouping by.
>
> the problem is that i want the row that contains the max date. the query is
> only returning the max date, with the other elements in the row coming from
> who knows where in the table.
>
> any idea on how i can achieve the complete row containing the max date???
>
