select id, sales_vol, (select avg(sales_vol) as mavg
from tbl b
where b.id between a.id - 3 and a.id)
from tbl a;
---
() ascii ribbon campaign against html e-mail
/\ www.asciiribbon.org
> -Original Message-
> From: sqlite-users-boun.
I hace many record of product database,and wanna count the moving average
value of sales_vol of last 3 days(id) of value, how to write sql command?
id Sales_vol mov_avg
1 1
2 2
3 3 =(1+2+3)/3
4 5 =(2+3+5)/3
5 4
And "You will" is _so_ geek. As are passive sentences. "Will"
indicates that the object that is in the future. It should never be
used for currently-running software, licensing, ...
we will be issued a userid
On 08/11/2012 01:39 PM, Philip Newton wrote:
> Hi there,
>
> http://www.hwaci.com/sw/
Hi there,
http://www.hwaci.com/sw/sqlite/cerod.html contains the sentence " This
utility program (called cerod_build.exe) reads an ordinary,
uncompressed and unencrypted SQLite database built by a public-domain
version of SQLite and constructs and equivalent compressed and
encrypted CEROD database
Am 10.08.2012 19:14, schrieb jean.nkengto...@externe.bnpparibas.com:
Hello,
I bet somebody already managed to make this work. Unhappily I can't access
archives.
Here is my problem:
I'm building a Console Application to load and fill one SQLite DB.
We recently decided to switch the application t
On 10 Aug 2012, at 9:14pm, u okafor wrote:
> We are doing a CREATE TABLE query; sqlite3_step() is called in shell.c and
> along
> the way, sqlite3VdbeExec() is called. sqlite3VdbeExec() call is pased with
> "p"
> pointer which contains "aOp" array. Could you please tell us where this "aOp"
>
Dear Forum members,
We are doing a CREATE TABLE query; sqlite3_step() is called in shell.c and along
the way, sqlite3VdbeExec() is called. sqlite3VdbeExec() call is pased with "p"
pointer which contains "aOp" array. Could you please tell us where this "aOp"
array
is created in the code...
Thank
Hello,
I bet somebody already managed to make this work. Unhappily I can't access
archives.
Here is my problem:
I'm building a Console Application to load and fill one SQLite DB.
We recently decided to switch the application to framework 4.0, from
framework 3.5.
I've downloaded and deployed dl
Hello,
will there be some improvement regarding concurrency in the new sqlite4 ?
Sqlite3 fits quite good to my needs, only the concurrency causes some
problems, so I am eager to know about improvements in this area.
Thx for your efforts
___
sqlite-
9 matches
Mail list logo