02-27-2018 01:19 PM
How do I write a case sum statement please? I have tried to write one but not 100% sure of the syntax?
create table R.TESTING_SUM as
(case when 'F1S','F2S','F3S','F4S','F5S','F6S') as FS_NEW,
(case when 'F1V','F2V','F3V','F4V','F5V','F6V') as FS_NEW,