sql server - How do I join the first row of a subquery? - Stack Overflow

I've thought about doing a left join on a subquery, but that doesn't seem very efficient. Does anyone have any T-SQL tricks to achieve this ...

stackoverflow.com