P Kishor <[email protected]> wrote:
> I think what Peng wants is that given table of type_id
>
> 5
> 5
> 5
> 5
> 5
> 4
> 4
> 4
> 7
> 7
> 8
> 8
> 8
> 8
>
> if 'n' is 3, the desired result is
>
> 5
> 5
> 5
> 4
> 4
> 4
> 7
> 7
> 8
> 8
> 8
>
> I don't know how to do that with sql.
Well, if you insist:
select type_id from foods f1
where (
select count(*) from foods f2
where f2.type_id = f1.type_id
and f2.rowid < f1.rowid) < 3;
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
