..> perl script.pl -d . --sql "select GeneID, (Tp1+tp2+tp3) as sum from x11114659 order by GeneId" |GeneID|sum| |------|---| |ABA5 | 17| |ALA1 | 33| |HUA4 |476| |THR8 |168| ------------