How to find the max row per group in SQL without subqueries

查詢 最大值的 row

http://www.xaprb.com/blog/2007/03/14/how-to-find-the-max-row-per-group-in-sql-without-subqueries/