I have a table with sampledate, meter1, meter2...etc
I am trying to develop a function or query
where:
select sampledate, (meter1 - (select meter1 where sampledate = sampledate +
interval '1 days')) as consumption from mytable;
Any ideas how to make this work?
Mark King