Re: [sqlite] SQLite API for counting number of records in a table.

2012-01-19 Thread Simon Slavin
On 19 Jan 2012, at 9:16am, bhaskarReddy wrote: >If i execute the command "SELECT COUNT (*) FROM table;" how > i will get the return value i.e., number of records in the table ? It is returned from that query just like the results of any other query. That command would return a

Re: [sqlite] SQLite API for counting number of records in a table.

2012-01-19 Thread bhaskarReddy
23:47, bhaskarReddy wrote: >> Is there an SQLite API for counting number of records in a table. > > No, but that is because regular SQL will do the trick: > >SELECT COUNT(*) FROM table; > > Roger > -BEGIN PGP SIGNATURE- > Ve

Re: [sqlite] SQLite API for counting number of records in a table.

2012-01-18 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 18/01/12 23:47, bhaskarReddy wrote: > Is there an SQLite API for counting number of records in a table. No, but that is because regular SQL will do the trick: SELECT COUNT(*) FROM table; Roger -BEGIN PGP SIGNATURE- Version: Gn

[sqlite] SQLite API for counting number of records in a table.

2012-01-18 Thread bhaskarReddy
Hi Friends, Is there an SQLite API for counting number of records in a table. Ex: StudentNameRollNo sub1sub2sub3 total avg abcd 188 99 88