List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:March 13 2013 2:58pm
Subject:Re: Retrieve most recent of multiple rows
View as plain text  
----- Original Message -----

> From: "Ananda Kumar" <anandkl@stripped>
> 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. 

Thread
Retrieve most recent of multiple rowsNorah Jones13 Mar
  • Re: Retrieve most recent of multiple rowsAnanda Kumar13 Mar
  • Re: Retrieve most recent of multiple rowsJohan De Meersman13 Mar
    • Re: Retrieve most recent of multiple rowsAnanda Kumar13 Mar
      • Re: Retrieve most recent of multiple rowsAnanda Kumar13 Mar
        • Re: Retrieve most recent of multiple rowsJohan De Meersman13 Mar
          • Re: Retrieve most recent of multiple rowsAnanda Kumar14 Mar
  • Re: Retrieve most recent of multiple rowshsv16 Mar