Group by show first result

Databases
1

Hi guys

This is my structure

08:00 1
08:15 1
08:30 1
08:45 2

I am using the following query

SELECT * FROM dates GROUP BY M_ID ORDER BY Date_Of_Actual_Booking ASC

which displays this

08:30 1
08:45 2

how can I get it to display like this

08:00 1
08:45 2

Thanks in advance

2

i have a feeling this is slightly over-simplified

could you do a SHOW CREATE TABLE please?