How to Select the First/Least/Max Row per Group in SQL Published Dec 7, 2006 by Baron Schwartz in Databases at https://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/ Here are some common SQL problems, all of which have related solutions: how do I find the most recent log entry for each program? How do I find the most popular item from each category? How do I fi