Selecting max n of each field value in SQL

I settled on the UNION ALL method for my problem, though there are other examples. See also this site

I wrangle code for Undrip and sling words for StartupGrind. Previously, I was Co-Founder and CTO of Plancast.

About me: About.me
My Plans: Plancast.com
My Notes: Noopsi.com
My Tweets: Twitter.com
My Code: Github.com
My Resume: LinkedIn.com
My Facebook: Facebook.com
My Google: Google.com