SQL or Death? Seminar Series – Spring 2025 – Carnegie Mellon Database Group

Re:SQL or Death? Seminar Series – Spring 2025 – Carnegie Mel... by _dain_ on Sunday February 02, 2025 @04:12AM (#42907378)

You 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).

[ Parent | on HN ]

Re:SQL or Death? Seminar Series – Spring 2025 – Carnegie Mel... by cyberax on Sunday February 02, 2025 @04:13PM (#42911888)

This 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.

[ Parent | on HN ]