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