sqlite - How to get the number of rows of the selected result from sqlite3?

Question

I want to get the number of selected rows as well as the selected data. At the present I have to use two sql statements:

one is

select * from XXX where XXX;

the other is

select count(*) from XXX where XXX; 

Can it be realised with a single sql string?

I've checked the source code of sqlite3, and I found the function of sqlite3_changes(). But the function is only useful when the database is changed (after insert, delete or update).

Can anyone help me with this problem? Thank you very much!

Answer 1

try this way

select (select count() from XXX) as count, * 
from XXX;