Blogs
Matching:
sum
X
Display: 
Why DB2 returns inaccurate SUM result on double column?
Question: Why the last query as below returns +6.60619999999999E+002 instead of +6.60620000000000E+002? $ db2 "create table tmp_day_act( avge_amount double)" $ db2 "insert into tmp_day_act values(1020)" $ db2...
from Blog: Thoughts from Support


Re: Sum of Pascal's triangle reciprocals
In response to: Sum of Pascal's triangle reciprocals Approved additions to these Online Encyclopedia of Integer
Sequences (OEIS): A000217 (end of
COMMENTS) A000292 (end of
COMMENTS) A000579 (FORMULA) Draft for THE...
from Blog: HermannSW


LISTAGG.. the real deal
SergeRielau
Tags:
aggregation
separated
listagg
comma
string
sum
aggregate
12 Comments
15,761 Views
One of the most popular blog entries on SQLTips4DB2 is the one on Aggregating Strings (October, 29 2010) . In this post I describe a means to sum strings into a a single comma separated text using XML. When I composed this post I was already working on a...
from Blog: SQL Tips for DB2 LUW


xs:decimal()
XSLT 2.0 data type xs:decimal is available on DataPower: http://publib.boulder.ibm.com/infocenter/wsdatap/v3r8m1/index.jsp?topic=/xs40/extensionfunctions146.htm By the XPath 2.0 spec xs:decimal has to be applied to an atomic type: http://www.w3.org/TR/xpath...
from Blog: HermannSW


Sum of Pascal's triangle reciprocals
Many binomial identities are known, and Pascal's triangle is well known, too.
I asked myself back in 1983 at school: What is the sum of the reciprocals of Pascal's triangle? Of course the sum is infinite because of the 1's on left and right border. ...
from Blog: HermannSW
