Re: [sqlite] Re: Re: Re: Select the top N rows from each group

2007-05-11 Thread Yuriy Martsynovskyy
Igor, Your query works now and returns 4 records. that was my mistake probably. Thank you! - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Re: Re: Re: Select the top N rows from each group

2007-05-11 Thread Igor Tandetnik
Yuriy Martsynovskyy <[EMAIL PROTECTED]> wrote: That's not quite true. ORDER BY and LIMIT are allowed in sub-selects, as is the case here. This query works, I tested it before posting. Your query returns 2 records instead of 4. I'm testing it on SQLite v3.3.10 Works for me. Returns 4 rows.