npearson99 <[email protected]> wrote: > The data looks like this for the minute and watts columns > Minute Watt > 1 100 > 2 110 > 3 111 > 4 95 > 5 120 > 6 90 > 7 15 > 8 220 > > It goes on like that for 8000+ records > > I want to average every four rows.
Perhaps something like this: select min(Minute), max(Minute), avg(Watt) from mytabe group by (Minute - 1)/4; Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
