not all the rows, only the distinct q_id,
On Wed, Mar 13, 2013 at 8:28 PM, Johan De Meersman <vegiv...@tuxera.be>wrote: > ------------------------------ > > *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. >