SQLite Forum

Restart a counter in a table based on a another field in the same table
Login
Actually you probably want to "order by 3,4".