in reply to Select all duplicates from SQLite

Since you are supplying it with a scalar ($duplicates), it only returns the first one. If you want them all, change the code to something like:

my @alldups = $dbh->selectall_arrayref( ... );

Then to access it, do something like:

while ( my $duplicates = pop(@alldups) ) { whatever... }
David Lee Crites
lee@critesclan.com