This content has been marked as final. Show 4 replies
Hi, I need help with doing this
I have this table :
sum(cant) as Cant,
sum(days) as Days
group by id, group, date;
Before this, i have three concatenates which add 3 new values.
and after that, i have to add new columns based in these previous values, so i use "resident"
sum(concatenate_value1) as concat1,
sum(concatenate_value2) as concat2
sum(concatenate_value1 + concatenate_value3) as concat 3
group by group by id, group, date;
But this isn't working, any idea with this ??