There is a table (let its name be schedule) of the form:
[id] [hour] [minutes] [1] [6] [35] [2] [7] [15] [3] [7] [35] [4] [8] [10] [5] [9] [50] [6] [9] [55]
I need to merge those rows in which the hour column matches.
What query do you need to perform on this table to get this result ?:
[id] [hour] [minutes] [1] [6] [35] [2] [7] [15 35] [3] [8] [10] [4] [9] [50 55]