List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:March 14 2013 6:19am
Subject:Re: Retrieve most recent of multiple rows
View as plain text  
not all the rows, only the distinct q_id,


On Wed, Mar 13, 2013 at 8:28 PM, Johan De Meersman <vegivamp@stripped>wrote:

> ------------------------------
>
> *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