not all the rows, only the distinct q_id,
On Wed, Mar 13, 2013 at 8:28 PM, Johan De Meersman <[email protected]>wrote: > ------------------------------ > > *From: *"Ananda Kumar" <[email protected]> > *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. >
