Ver originaluse test; drop table if exists vista_general_personas; create table vista_general_personas (id int); insert into vista_general_personas values (1),(2),(3),(4),(5),(6),(7),(8),(9); DROP PROCEDURE IF EXISTS totales; DELIMITER $$ CREATE PROCEDURE totales() BEGIN DECLARE t INT; DECLARE valor INT DEFAULT 0; SELECT count(*) INTO t FROM vista_general_personas; SET valor = t - 2; SELECT * FROM vista_general_personas LIMIT valor; END $$DELIMITER ; call totales();