Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi, Here is a HSQL statement that might do for you....!

I am attaching a PDF to show you output of this HSQL ..... Hope it helps.

SELECT "ID", "Val_1", "Val_2", "Val_3", "Val_1" + "Val_2" + "Val_3" AS "RESULT", CASEWHEN( ( "Val_1" + "Val_2" + "Val_3" ) > 0, 'Yes', 'No' ) AS "Logic_YesOrNo" FROM "TableName"

SORRY DUE TO LOW KARMA, I COULDN'T UPLOAD FILE....SORRY!