# SQL POWER Function

This SQL Mathematical Function is used to calculate the power for the specified expression or numerical value, and its syntax is

```SELECT POWER (Float_Expression, Value)
FROM [Source]```

## SQL POWER Function Example

This SQL math Function calculates the power of a given numeric value. The following query shows multiple ways to use it.

First, we declared a float variable, and we used it to calculate the power of the variable @i. It means, @i * @i * @i = 2 * 2 * 2 = 8. In the next SQL Server statement, we used 4 as the second argument. It means 2 * 2 * 2 * 2 = 16

We used the integer value as the SQL Power function input within the first two select statements. It means, (@j, 3) = @j * @j * @j => 2.20 * 2.20 * 2.20 = 10.65. But we are getting 8 as a result because it is rounding the 2.20 value to 2

```DECLARE @i float = 2, @j int = 2.20

SELECT POWER(@i, 3) AS [SQLPowers]

SELECT POWER(@i, 4) AS [SQLPowers]

-- Calculating directly
SELECT POWER(3.20, 3) AS [SQLPowers]

-- Wrong Value
SELECT POWER(@j, 3) AS [SQLPowers]
SELECT POWER(2.20, 3) AS [SQLPower]```

NOTE: Use float variables as this Mathematical Function input. Otherwise, you may expect strange results.

This Function also allows you to calculate the power of column values. In this SQL Server math function example, We are going to calculate the power of three for all the records present in [Sales Amount]. For this demo, we use the below table data

```SELECT [EnglishProductName]
,[Color]
,[StandardCost]
,[SalesAmount]
,POWER([SalesAmount], 3) AS Sales
FROM [Mathemetical Functions]```

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.

Back to Categories SQL