samedi 16 avril 2016

How do I make sqlite output a row that looks like this?

I have a table like this

CREATE TABLE BA (Datum NUMERIC,BU NUMERIC, GU NUMERIC, OUL NUMERIC, OUR NUMERIC, Note TEXT);

Datum is a linux date.

How do I make sqlite output a row that looks like

(Datum of last row minus Datum of previous row) | (BU of last row minus BU of previous row) | (GU of last row minus GU of previous row) | (OUL of last row minus OUL of previous row) | (OUR of last row minus OUR of previous row)

Aucun commentaire:

Enregistrer un commentaire