I always enjoy those articles.
But about the salary question: I suggest using ROW_NUMBER() in combination with a CTE. With that basis you can easily select any position (third, fourth, etc.).
And offset is inefficient with large datasets, b/c it does a full table scan.