I like your solution...I've posted mine on my blog (www.TheBakersDozen.net)

I admit, I like the LIMIT statement - it doesn't do "everything" that ROW_NUMBER OVER (PARTITION BY...) can do - but I admit, it is nice.

If nothing else, people can see there are different ways to approach things.

Thanks,
Kevin