SELECT column1, column2, .. 

##</code><code>##

while ( my $href  = $sth->fetchrow_hashref() ) {
   my $col1 = $href->{column1};
   my $col2 = $href->{column2};
   ...
}