[nmglug] query masters??

[Bill York]

try this

SELECT parent_id, question_id, Max(id) AS LastRecord FROM
xxYourTablexx GROUP BY parent_id, question_id HAVING parent_id="1"


---
Bill York
762-233-7568


On Fri, Mar 4, 2011 at 2:48 PM, Andres Paglayan <andres at paglayan.com> wrote:

>  Hey,
>
> I need a query for the following,
>
> given a table with this vales
>
> | id | parent_id | question_id |
> | 1  |  1             | 1                  |
> | 2  |  1             | 1                  |
> | 3  |  1             | 2                  |
> | 4  |  1             | 2                  |
>
>
> Knowing only that I am searching for the parent_id = 1
> I need a query that searches for
> parent_id = 1 and then for each matching record, the older entry,
> meaning the result should only have the records with id 2 and 4,
>
> any hint?
>
>
>
>
> _______________________________________________
> nmglug mailing list
> nmglug at lists.nmglug.org
> http://lists.nmglug.org/listinfo.cgi/nmglug-nmglug.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nmglug.org/pipermail/nmglug-nmglug.org/attachments/20110304/fed39b9f/attachment.htm>