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. You are doing something wrong.

Igor Tandetnik

-
To unsubscribe, send email to [EMAIL PROTECTED]
-