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
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
On Mon, Apr 18, 2011 at 08:45:49AM -0700, Danny scratched on the wall:
> Hello
>
> I have a table with a primary key consisting of three columns: Book,
> Chapter, Verse.
>
> I'd like to produce a results set that contains 1 row for each chapter of
> each book, showing the total verses in that
Should your query not be something like this:
select count(*) from blocklists where blockval like '%alexandre%'
RBS
-Original Message-
From: Alexandre Busquets Triola [mailto:[EMAIL PROTECTED]
Sent: 24 November 2006 23:48
To: sqlite-users@sqlite.org
Subject: [sqlite] select help
4 matches
Mail list logo
