SQLite power() Function

You organize your data. Now organize your savings.

Set savings goals, track your progress, and stay on course.

Get Savigo for iPhone ›

Summary: in this tutorial, you will learn how to use the SQLite power() function to raise a number to a specific power.

Introduction to SQLite power() function #

The power() function allows you to raise a number to a specific power.

Here’s the syntax of the power() function:

power(base, exponent)Copy

In this syntax:

• base: is the base number.
• exponent: is the exponent you want to raise the base number.

The power() function returns the base raised to the power exponent. It returns NULL if either base or exponent is NULL.

Please note that the power() and pow() function are synonyms, therefore, you can use them interchangeably.

SQLite power() function examples #

Let’s explore some examples of using the power() function.

1) Basic power() function examples #

The following statement uses the power() function to raise the number 2 to the power of 3:

SELECT power(2,3) result;Copy

Output:

result
------
8.0Copy

Likewise, you can use the power() function with decimal numbers:

SELECT power(2.5, 3) result;Copy

Output:

result
------
15.625Copy

2) Using the power() function with decimal exponents #

The following example uses the power() function to raise the number 1.5 to the power of 2.5:

SELECT power(1.5, 2.5) result;Copy

Output:

result
------------------
2.7556759606310752Copy

Please note that the return value is approximate, but not accurate.

Summary #

• Use the power() function to raise a number to a specific power.