|
|
|
|
Browse by Tags
All Tags » SQL » Set based logic (RSS)
-
You can use SUM to calculate the sum of several numbers, but
you cannot directly use set-based logic to calculate a product. Yet there is a
very simple trick – you can use EXP(SUM(LOG(…))) and get a product of several
numbers without a loop. The trick was originally posted on newsgroups by Tom Cooper.
For example, suppose that you have to ...
|
|
|
|
|