returning average values

Discussion created by ygalipeau on Jan 11, 2012
Latest reply on Jan 12, 2012 by kilgored

good evening,


i am using the pi oledb console for testing some pioledb queries. the following query works


select count(value) from piarchive..piinterp2 where tag = 'sinusoid' and time >= 't' and time < '*' and timestep = '10m'


but if i am changing the count for max or avg i have an error saying: Overload Resolution Failed for (max) argument(s).




is there a way to get the average or max of the values? i don't want to bring back all the data in a table and do the average or max on the records, but retreive directly the aggregates from the SQL query. also, i need to force a value each 10 minutes, so i cannot use the piavg or pimax table