meaning of =sum(col1*col2) expression

[Anonymous]

hi,

can anybody explain how the above expression works?

[sunny_talwar]

Multiply col1 and col2 at row level and then sum them....

[Anonymous]

no it showing me some different value

[sunny_talwar]

I am not seeing what you are... so I don't really know what you mean

[Anonymous]

this is my output, I don't think this is the correct output as you said

[sunny_talwar]

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

[Anonymous]

ohhh yes thank you.

[sunny_talwar]

If you got what you wanted, I would suggest you to close this discussion by marking correct and helpful responses.

Best,

Sunny