joepreludian · August 29, 2015 14:02
diff --git a/select_rank.sql b/select_rank.sql
 SET @rank = 0;

 SELECT 
 	* 
 FROM 
 (
 	SELECT 
 		@rank :=@rank + 1 AS ranking,
 		id as chamado,
 		nome,
 		status
 	FROM 
 		chamado
 	WHERE
 		status = 'IDLE'
 	ORDER BY
 		chamado ASC
 ) AS 
 	chamado_by_rank
 WHERE
 	ranking <= 3; -- ou chamado = <id_do_chamado>
	SET @rank = 0;

	SELECT
	*
	FROM
	(
	SELECT
	@rank :=@rank + 1 AS ranking,
	id as chamado,
	nome,
	status
	FROM
	chamado
	WHERE
	status = 'IDLE'
	ORDER BY
	chamado ASC
	) AS
	chamado_by_rank
	WHERE
	ranking <= 3; -- ou chamado = <id_do_chamado>