Thanks everyone. That was so easy it was embarrassing! :) --- On Mon, 4/18/11, Simon Slavin <slav...@bigfraud.org> wrote:
> From: Simon Slavin <slav...@bigfraud.org> > Subject: Re: [sqlite] SELECT help for newbie > To: j...@kreibi.ch, "General Discussion of SQLite Database" > <sqlite-users@sqlite.org> > 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
