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 single row with a single column containing the count. If you want to test a SQLite command you can't do better than use the sqlite3 shell tool to try it out and see whether it does what you want: <http://www.sqlite.org/sqlite.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users