"Mahalakshmi.m" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > My table has records as follows: > > Id Track > 1 zz > 2 aaa > 3 cc > 4 aaa > 5 aaa > 6 aaa > > 1st 2 records -> SELECT Id, Track FROM MUSIC ORDER BY Track LIMIT 2; > > Output: 2 aaa > 4 aaa > > Next 2->SELECT Id, Track FROM MUSIC WHERE Track > aaa ORDER BY Track > LIMIT 2 > > Output: 3 cc > 1 zz > > But I want 5 aaa > 6 aaa
select id, track from music order by track, id limit 2; select id, track from music where track>'aaa' or (track='aaa' and id>4) order by track, id limit 2; Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
