SQL query in MYSQL that I grouped the data by time segment

0

I am trying to do an SQL query where I group the result in time segments, that is, calculate the average of a data every 5 min, my query for now goes like this:

SELECT DATE AS DATE, method AS METHOD, red AS red, state AS STATE
FROM table
WHERE STATE = 155
GROUP BY DATE
    
asked by Jesús Henríquez 19.10.2018 в 16:13
source

0 answers