Average every n records
Hi everyone,
I have a simple database made of 2 columns: id, temperature.
I am populating it every 5 seconds with a new reading which means that after 24h i will have 17280 new records.
Can anyone help me converting the last 17280 records into a set of (for instance) 1440 representing the average of temperatures recorded per minute, i.e. calculate the average temperature every 12 records?
Thanks in advance.
Subject
Written By
Posted
Average every n records
April 10, 2018 10:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.