Tor Erik Berg

Hi!

Have this query

SELECT * FROM gpstrackerclubs GROUP BY flightnumber ORDER BY id DESC

Gives me flightnumber 1..4 and thats fine
But must return flighnumber 1...4 with the newest record for every flightnumber

Hi!

Have this table

Need help on this one.

What i want:

Flightnumer (se image) is here 1 to 4
Want result of the newest records for flight : 1,2,3 and 4

This example must return

Flightnumber               timeused.           id

1                                    0                         14

2                                    5                         15

3                                    3                         17

4                                    7                         13   

How can i do this ?