Yuriy Martsynovskyy
<[EMAIL PROTECTED]> wrote:
select * from (select * from fruits where type = 'apple' order by
price limit 2) union all
select * from (select * from fruits where type = 'orange' order by
price limit 2)
SQlite allows only one LIMIT clause per query, that is applied to the
final resultset
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.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
