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
Is there any other way for doing this or I have to use Limit, Offset only to
solve this.
For Previous 2:
SELECT Id, Track FROM MUSIC WHERE Track < aaa ORDER BY Track DESC LIMIT 2;
Thanks & Regards,
Mahalakshmi
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
