On 12/8/08, Oscar Alejandro Alvarado Prieto <[EMAIL PROTECTED]> wrote: > how can I retrieve the result of a "SELECT COUNT(*) FROM atable" statemen? > thanks > >
Hi Oscar, As MikeW mentioned, please use a subject line more descriptive than "newie question." Additionally, please pose a better question as well. Martin already explained some of the basics, but your question, as is, doesn't make any sense. "SELECT COUNT(*) FROM atable" *is* the way to retrieve the result. If you run that query in the sqlite3 shell, or through the interface of your choice, you will get back a count of rows in atable. Perhaps you want to provide some additional information about where and how you want to "retrieve" the desired result. -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users