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

August 10, 2023 by Tarik

try this way

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