Tor Erik Berg
-
Posts
2 -
Joined
-
Last visited
Tor Erik Berg's Achievements
Newbie (1/7)
0
Reputation
-
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 ?
