Suppose I have a table like the following:
tblNumbers
Numbers
4
5
3
6
Using SET BASED approach how can I perform a multiplication so the output will be:
Output
360
N.B~ There is no hard and fast rule that there will be only four numbers, but I'd prefer the answer to be using a CTE and/or correlated subquery.