Hacker News new | comments | show | ask | jobs | submit login

I literally just ran into the same issue with SQL Server. Since we're running an older version, I was very confused when I found the alternative to MySQL's "LIMIT"-- it wasn't pretty.

I like how they timed something everyone has wanted for like a million years with the switch to per-core pricing lol.

What was wrong with ROW_NUMBER()? It worked just fine for me, and partitioning was frequently useful.

Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | DMCA | Apply to YC | Contact