I’m using Postgres.

I want to have a row always on top (example alias = ‘abc’) in a query regardless of the offset being used.

Right now, I’m doing

ORDER BY
CASE
    WHEN alias = 'abc' THEN 0
    ELSE 1
END
, avg_xyz
    DESC            
LIMIT 11 OFFSET 10;

but it doesn’t work because of OFFSET. Works if OFFSET is 0.