3 ms·
Actually, you don't have to. Any first element would do, even if it's a random one. It's perfectly possible to do `SELECT * FROM blah LIMIT 1`, after all.
by cyberax 2y ago
Actually, you don't have to. Any first element would do, even if it's a random one.
It's perfectly possible to do `SELECT * FROM blah LIMIT 1`, after all.
- _dain_ 2y agoYou can use ANY_VALUE to get an arbitrary value from a GROUP BY. There's also FIRST_VALUE for a window function (though that requires you specify an order).
- cyberax 2y agoThis is a non-standard extension, and it also doesn't allow the selection of the _first_ element in a group. Even if the group is actually ordered.