MySQL - How To Get Top N Rows per Each Group - SQLines Tools

Question: How to return the 2 largest cities for each country? Sample Data Assume we have the following table definition and data: CREATE TABLE cities ( city VARCHAR(80), country VARCHAR(80), population INT ); INSERT INTO cities VALUES ('New York', 'United States…