SELECT id,sl1,rank
FROM
(
SELECT t.*, IF(@p=id,@r:=@r+1,@r:=1) AS rank,@p:=id FROM t,(SELECT @p:=NULL,@r:=0) r
ORDER BY id
)s;