SQL queries are seldom considered examples of neatness, but the top solution (which is a good one, as far as my rusty TSQL allows me to judge) is a textbook example of a kludge.
Not that I think OFFSET and LIMIT belong in SQL (IIRC, ANSI folks agree). It's a query language, not a presentation one.
Not that I think OFFSET and LIMIT belong in SQL (IIRC, ANSI folks agree). It's a query language, not a presentation one.