In this blog post “Order max and min value rows alternatively in SQL Server”, we are going to learn how we can order the rows of a table by combining max and min value rows alternatively. For example, from an employee table based on the salary column, we need to extract the records ordered as;
First row: First highest salary
Second row: First lowest salary
Third row: Second highest salary
Fourth row: Second lowest salary
Fifth row: Third highest salary
Sixth row: Third lowest salary
and so on…….
We know that the SQL Server database engine is optimized to operate in a set oriented way instead of RBAR (Row By Agonizing Row, processing row by row in a loop). We are going to achieve the desired output in a set based approach, unlike loops or recursive CTEs. Let’s have this tutorial in action now.
Create the dummy employee table and … More