top n rows per group

Often database developers need to select top n rows per group in a table. Here are different ways to get top rows per group in MySQL.