Is it possible to group a range of values?

Question

I made the following consultation:

`select t.net, t.hora, t.`data`, t.`local` from domingos t
join(
select net, updated, count(*) from domingos
where `data` = '07/05/2017'
group by updated, net
having count(*) > 4
) as u
on t.updated = u.updated
and t.net = u.net
group by t.net, t.hora, t.`data`, t.`local`
order by hora;`

This query returns the values in the figure below

Is there any parameter for group by that makes it possible to group the values of the column hora whereas, for example, the values 00:34:00 to 00:36:00 are represented by only one value?

Answer 1

Try this:

SELECT t.net, u.hh, t.`data`, t.`local`
FROM domingos t
JOIN (
    SELECT net, updated, HOUR(hora) AS hh, COUNT(*)
    FROM domingos
    WHERE `data` = '07/05/2017'
    GROUP BY updated, net
    HAVING COUNT(*) > 4
) AS u
ON t.updated = u.updated
AND t.net = u.net
GROUP BY t.net, u.hh, t.`data`, t.`local`
ORDER BY hora;

I mean, instead of using t.hora in the GROUP BY and in the SELECT, use the u.hh which is the HOUR(hora).