Nadya,

>Mohammed Qasem gave me a quite interesting problem, which I am now (12:13am) trying to solve the most elegant way.

Al and Sergey both posted what I consider the elegant way. But be warned prior to Europa TOP N can return more than N rows if there are ties in the last rows, so more work must be done to check for and eliminate them.