The POWER function is used to raise a number to the power specified (m**n). The base number m is raised to the nth power. Both m and n can be any number except that if m is a negative number, b must be an integer.
This function is useful in growth calculations, for instance to answer the question: If table X grows by 5% per month how big should I make its initial extent if I need 50K bytes to store the data I currently have?In this case, the table is growing at a rate of 1.05 times the base size per month, over a period of a year this is 1.05*1.05*1.05....twelve times or 1.05**12.
power(m,n)
if m is a negative number, b must be an integer.如果m是负数，n必须为整数
This function is useful in growth calculations, for instance to answer the question: If table X grows by 5% per month how big should I make its initial extent if I need 50K bytes to store the data I currently have?In this case, the table is growing at a rate of 1.05 times the base size per month, over a period of a year this is 1.05*1.05*1.05....twelve times or 1.05**12.
power(m,n)
if m is a negative number, b must be an integer.如果m是负数，n必须为整数
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货