How does one get the number of rows in an SQL database?(Android SDK) <p>I looked for this on SO and saw this(and others like it): <a href="http://stackoverflow.com/questions/3408669/sql-direct-way-to-get-number-of-rows-in-table">sql direct way to get number of rows in table</a>, however, Select is shown as a token as is count. I tried to use mDb.execSQL() but that only returns void. Any help on how to do this would be appreciated. The code is:<br> public int getRowNumber(){ return mDb.execSQL("SELECT COUNT(*) FROM notes");} I get an error that says "cannot return void result". </p>