ROW_NUMBER functionality helps you to give temporary figures to the result set of the question and it may be also used in place of the TOP clauses. Such as, the following question will return the first 4 rows on the Item desk.END In this question, we use CASE to outline the salary variety for each staff. You can see a similar CASE statement 2 times