in reply to Count the Duplicate Entries and make them uniq
For some reason, it works in SQLite, but CSV returnsselect distinct OS, RELEASE, (select count(1) from $table as y where x.OS=y.OS and x.RELEASE=y.RELEA +SE and y.LIKE='Yes'), (select count(1) from $table as y where x.OS=y.OS and x.RELEASE=y.RELEA +SE and y.LIKE='No') from $table as x;
DBD::CSV::db prepare failed: Unbalanced parentheses! at .../perl/lib/p +erl5/SQL/Statement.pm line 88
|
|---|