mardi 19 mai 2015

How to get total no. of rows , when using LIMIT in SQLite

I have a table like this.

test

id      name

1       first
2       second
3       third
4       fourth
5       fifth

I am using pagination concept in my Android application .

I have to use a LIMIT of 3 rows . But also total no. of rows in this table .

How can i do this is SQLite database in one query ?

Aucun commentaire:

Enregistrer un commentaire