Thanks everyone. That was so easy it was embarrassing! :)
--- On Mon, 4/18/11, Simon Slavin wrote:
> From: Simon Slavin
> Subject: Re: [sqlite] SELECT help for newbie
> To: j...@kreibi.ch, "General Discussion of SQLite Database"
>
> Date: Monday, April 18, 2011, 1:
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
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 chapter.
I know enough SQL to know I can get the total number of verses in a chapter
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] s
Hi have this table
CREATE TABLE [blocklists] (
[blockval] VARCHAR(255) NOT NULL
)
insert into blocklists blockval values('%lex%');
and I need do something like this
select count(*) from blocklists where 'alexandre' like blockval
How i can do something like with sqlite?
That i need is som
6 matches
Mail list logo
