Thanks everyone. That was so easy it was embarrassing! :) --- On Mon, 4/18/11, Simon Slavin <[email protected]> wrote:
> From: Simon Slavin <[email protected]> > Subject: Re: [sqlite] SELECT help for newbie > To: [email protected], "General Discussion of SQLite Database" > <[email protected]> > Date: Monday, April 18, 2011, 1:06 PM > > On 18 Apr 2011, at 4:52pm, Jay A. Kreibich wrote: > > > SELECT book, chapter, count(verse) AS > total_verses > > FROM scripture > > GROUP BY 1, 2; > > Just for clarity, since he's still learning, I might > suggest instead > > SELECT book, chapter, count(verse) AS total_verses > FROM scripture > GROUP BY book, chapter; > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
