Posted by Ridge Burner on 04/11/06 03:53

I'm using MySQL 5.0.18-Debian_8, sorry guess I should have said. :O


"Tim Van Wassenhove" <timvw@users.sourceforge.net> wrote in message
news:e1es7d$sap$3@ikaria.belnet.be...
> On 2006-04-10, Ridge Burner <nospam@nospam.com> wrote:
>> I'm looking for a SQL statement like so:
>>
>> $sql = "SELECT first 3 items for each UNIQUE user ORDER BY date_added
>> ASC";
>
> I can only think of a solution where you perform a subquery to get the
> desired results. Which SQL-DBMS are you using? And which version? If i'm
> not mistaken MySQL only supports subqueries since version 4.1.
>
> --
> Met vriendelijke groeten,
> Tim Van Wassenhove <http://timvw.madoka.be>

[Back to original message]