WITH cte AS ( SELECT * FROM m_paciente mp WHERE apellido like 'P%' ) SELECT * FROM ( TABLE cte ORDER BY apellido, nombre LIMIT 10 OFFSET 190 ) sub RIGHT JOIN (SELECT count(*) FROM cte) c(full_count) ON true;
WITH cte AS ( SELECT * FROM m_paciente mp WHERE apellido like 'P%' ) SELECT * FROM ( TABLE cte ORDER BY apellido, nombre LIMIT 10 OFFSET 190 ) sub RIGHT JOIN (SELECT count(*) FROM cte) c(full_count) ON true;