Re: [sqlite] How to select data from 2 lines in one line?

Both work for me, Kit solution is very fast, but I think John is right. In my case, the tables have sequencial rowid. If I delete some row, then will not work anymore. On Wed, Aug 19, 2009 at 12:44 PM, John Machin wrote: > On 20/08/2009 12:57 AM, Kit wrote: > > Right form

Re: [sqlite] How to select data from 2 lines in one line?

I said its slow but I forget index. Now is as fast as a lightningbolt!! Thanks again! On Wed, Aug 19, 2009 at 12:23 PM, Mário Anselmo Scandelari Bussmann < mario.bussm...@gmail.com> wrote: > Bingo! This works very well (a little bit slow, since I have a 30 > rows). T

Re: [sqlite] How to select data from 2 lines in one line?

Bingo! This works very well (a little bit slow, since I have a 30 rows). Thank you all!!! On Wed, Aug 19, 2009 at 11:42 AM, John Machin <sjmac...@lexicon.net> wrote: > On 20/08/2009 12:10 AM, Mário Anselmo Scandelari Bussmann wrote: > > I have a table like this

[sqlite] How to select data from 2 lines in one line?

I have a table like this: petr4 --- rowid|data|preabe|premax|premin|preult|voltot 1|2007-01-02|50.0|50.45|49.76|50.45|256115409.0 2|2007-01-03|50.16|50.4|48.01|48.7|492591256.0 3|2007-01-04|48.5|48.75|47.4|47.65|505916186.0 4|2007-01-05|47.2|47.99|45.1|46.19|581485748.0