SELECT fldtrue, SUM(fldsum) FROM table GROUP BY fldcode,fldtrue WHERE fldtrue; UNION ; SELECT .F.,SUM(fldsum) FROM table WHERE !fldtrue>I have a table with below record:
>FldCode FldTrue FldSum > 21 T 10000 > 21 T 20000 > 22 T 30000 > 23 F 40000 > 24 F 50000 >>I want to write a SQL statment that return below result:
>FldCode FldTrue FldSum > T 30000 > T 30000 > F 90000 >>( I want Sum of similar FldCode and so Sum of records that FldTrue = .F. )