>>Generally, it would be nice if we had a first() or last() aggregate function, so we could use them on such fields where we don't really care from which record will the value come.
>
>Max() or Min() are often good enough for code needing to run under set enginebehaviour <80, so that is my standard "fix" without really rewriting the code of old queries.

It's mine too - it's just that I think first() and last() would be considerably faster.