Active record, offset limit with mssql

[eluser]0plus1[/eluser]
I encountered a small problem, I have a methiod inside a model:

Code:

function lista($limit="0",$offset="0")
    {
        $query = $this->db->get('AN_ANAGRAFICA_AZIENDE', $limit, $offset);
        return $query->result();
    }

When I call it from the controller and then push the result from the list I get incremental results:

Code:

$data['lista'] = $this->Mana->lista(10,120);

Theoretically I would start from record 120 and limit results by ten, in reality it returns 130 rows.. How come? The same thing happens the other way around..

Can you explain what I'm doing wrong/missing?

Thank you