SQL Window Functions: How to Get the Top Row Per Group

By the end of this page you can answer the question that stops most people the first week they write SQL: which row is the best one in each category. You will know OVER and PARTITION BY, the three ran