SQL when I policyno this field is empty, the LEVEL1COMDESC this field assignments for the "tota-CodePudding

Home > database > SQL when I policyno this field is empty, the LEVEL1COMDESC this field assignments for the "tota

SQL when I policyno this field is empty, the LEVEL1COMDESC this field assignments for the "tota

Time：10-05

CodePudding user response:

The column LEVEL1COMDESC into the following
Case the when policyno is null then the 'total' else LEVEL1COMDESC end as LEVEL1COMDESC

CodePudding user response:

This can add in the back of the select?