Tom Lane <tgl@xxxxxxxxxxxxx> writes: > Egad :-(. At least the SQL spec has some notion of wanting the answer > to a query to be well-defined ... Yeah, the MySQL interpretation of this is basically as a shorter form of Postgres's DISTINCT ON syntax. There's something to be said for MySQL's which doesn't introduce an orthogonal syntax to GROUP BY with basically equivalent meaning, but there's a lot to be said for having a syntax that you can't write by accident as well. -- greg
