One very common question asked at the time of interview is to write query for finding the 2nd highest salary. But, it becomes more trickier when asked to find nth highest salary. Like, 3rd highest or 10th highest salary. Check this post.
Read this post on techiners.blogspot.com