SQLite Tutorial SQLite Advanced SQLite Database SQLite References

SQLite POW() Function



The SQLite POW() function returns the base raise to the power of exponent. In special cases it returns the following:

  • If the exponent is zero, then 1 is returned.

The POW() function is a synonym for the POWER() function.

Syntax

POW(base, exponent)

Parameters

base Required. Specify the base.
exponent Required. Specify the exponent.

Return Value

Returns the base raise to the power of exponent.

Example 1:

The example below shows the usage of POW() function.

SELECT POW(5, 2);
Result: 25.0

SELECT POW(3, 5);
Result: 243.0

SELECT POW(5.5, 2);
Result: 30.25

SELECT POW(5.5, 2.1);
Result: 35.872500303491

SELECT POW(5, -1);
Result: 0.2

SELECT POW(5, 0);
Result: 1.0

SELECT POW(0, 5);
Result: 0.0

Example 2:

Consider a database table called Sample with the following records:

Datax
Data 10.5
Data 21
Data 35
Data 410
Data 550

The statement given below can be used to calculate the square root of column x.

SELECT *, POW(x, 0.5) AS POW_Value FROM Sample;

This will produce the result as shown below:

DataxPOW_Value
Data 10.50.707106781186548
Data 211.0
Data 352.23606797749979
Data 4103.16227766016838
Data 5507.07106781186548

Example 3:

Consider a database table called Sample with the following records:

Dataxy
Data 10.52
Data 213
Data 354
Data 4103
Data 5503

To calculate the records of column x raised to the power of records of column y, the following query can be used:

SELECT *, POW(x, y) AS POW_Value FROM Sample;

This will produce the result as shown below:

DataxyPOW_Value
Data 10.520.25
Data 2131.0
Data 354625.0
Data 41031000.0
Data 5503125000.0

❮ SQLite Functions