$rows = $dbh->selectall_arrayref(
            "                   
                SELECT name,age,gender
                FROM people
            ", { Slice => {} }  
        );                                           
         
foreach my $row (@$rows) {  
    my $name = $row->{name};
    my $age  = $row->{age};
    my $gender = $row->{gender};
}

##</code><code>##

$ { $array_ref } [2]