Selecting a specific non aggregated column data in GROUP BY

(Shlomi Noach) In a GROUP BY query, MySQL may allow specifying non aggregated columns. For example, using MySQLs world database, I wish to get the number of countries per continent, along with a sample country:

Read More - Register for Free Membership