...
my $sql  = "select id, account_number, date
                from my_table where id <>''
                order by date desc";

    my $results = $self->_all_data($sql);
...