----- Original Message ----- > From: "Ananda Kumar" <anan...@gmail.com> > Subject: Re: Retrieve most recent of multiple rows
> select qid,max(atimestamp) from kkk where qid in (select distinct qid > from kkk) group by qid; What use is that where statement? It just says to use all the rows in the table. -- Unhappiness is discouraged and will be corrected with kitten pictures.
