SQLite Forum

Can you see what I do wrong?
Login
OK, thanks.

But what if my `SELECT` did not include the column whose `max()` I wanted?

What if I needed to return only the `name`, `dt`, and `time_in` from the group row that has the maximum `time_out` value?

Is there some way for `HAVING` to match the row with the lexicographically higher string value without resorting to more complicated solutions using sub-queries?