Date sent: Thu, 01 Jan 2004 23:42:17 +0100
To: [EMAIL PROTECTED]
From: Hennie Peters <[EMAIL PROTECTED]>
Subject: Re: [sqlite] Find a row
> to get the number of rows:
> select count(*) from testtableint;
> or the n
to get the number of rows:
select count(*) from testtableint;
or the next on might be quicker:
select count(1) from testtableint;
How can you be sure that the first row contains the lowest rowid when doing:
"select rowid,. from testtableint where rowid>2 limit 1"
Would you need to do:
"select r
>
> Is it really much quicker than:
> select min(rowid) from testtableint having rowid>2;
> and is there a way to show the time a query takes to execute ?
I guess this what you mean:
select min(rowid) from testtableint where rowid>2
because having can only be used together with "group by"
I thin
At 08:14 1-1-2004 -0500, D. Richard Hipp wrote:
[EMAIL PROTECTED] wrote:
What I am searching for is when I retrieved Row 2, I want to go to Row 3,
and find an efficient way to do this.
What I tried is this
First go to Row 2, doesn't matter how, but I found the RowID belonging to
Row 2
I want to d
[EMAIL PROTECTED] wrote:
What I am searching for is when I retrieved Row 2, I want to go to Row 3, and find
an efficient way to do this.
What I tried is this
First go to Row 2, doesn't matter how, but I found the RowID belonging to Row 2
I want to do (what is called in Delphi way of data-access
First, a happy newyear to all!!!
I have a question /problem, which I hope someone can find an answer / solution
to.
It is about rowid
Let's say I have a table looking like this
rowid, rest
1, .
2,
3,
4,
5,
6,
7,
I delete the row wh
6 matches
Mail list logo