Say I have a table like this: CREATE TABLE COUNTRIES(COUNTRY TEXT, CITY TEXT, POPULATION INTEGER)
What would be the SQL to get 3 cities for each country with the highest 3 populations for that country? So, for example for the United Kingdom it would show London, Birmingham, Manchester in that order, and for the USA New York, Los Angeles, Chicago. So, I would like these top 3 cities for all countries. RBS _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
