ROW_NUMBER purpose helps you to give short-term numbers to the result list of the query and it can be also utilised rather than the TOP clauses. As an example, the following query will return the first 4 rows with the Product desk.Conclusion In this question, we use CASE to define the salary