Chris So
1 min readJul 28, 2020

--

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.

--

--

Chris So
Chris So

Written by Chris So

Data Dude and SQL enthusiast. Occasionally does Pixel art◾

No responses yet