SQLite Forum

Thanks a lot.It worked. Instead of Order by changed to Partition by.