SQLite Forum

Select distinct from most recent record
Login
The most likely answer is that col2 contains strings, not numbers.  And a string starting with a 9 is bigger (sorts after) than any string starting with 0, 1, 2, 3, 4, 5, 6, 7, or 8.