can anybody explain how the above expression works?
Multiply col1 and col2 at row level and then sum them....
no it showing me some different value
I am not seeing what you are... so I don't really know what you mean
this is my output, I don't think this is the correct output as you said
You seem to have 2 rows for id = 3 and id2 = 4... check the table viewer by pressing Ctrl + T and then right click on your table to click on preview
ohhh yes thank you.
If you got what you wanted, I would suggest you to close this discussion by marking correct and helpful responses.
Retrieving data ...