The SQL POWER Function is one of the Mathematical Function which used to calculate the power for the specified expression or numerical value.

## SQL POWER Function Syntax

The basic syntax of the POWER Function in SQL Server is as shown below:

1 2 |
SELECT POWER (Float_Expression, Value) FROM [Source] |

In this article we will show you, How to write POWER Function in SQL Server with example. For this, We are going to use the below shown data

## SQL POWER Function Example 1

The POWER Function in SQL is used to calculate the power of a given numeric value. The following query will show multiple ways to use POWER function.

**T-SQL CODE**

1 2 3 4 5 6 7 8 9 10 11 12 |
DECLARE @i float = 2, @j int = 2.20 SELECT POWER(@i, 3) AS [SQL Powers] SELECT POWER(@i, 4) AS [SQL Powers] -- Calculating Power directly SELECT POWER(3.20, 3) AS [SQL Powers] -- Wrong Value SELECT POWER(@j, 3) AS [SQL Powers] SELECT POWER(2.20, 3) AS [SQL Power] |

**OUTPUT**

**Analysis**

Below lines of code is used to declare float and int variable and assigning the values.

1 |
DECLARE @i float = 2, @j int = 2.20 |

In the below statement, We used POWER function to calculate the power of the variable @i. We also assigned new name to that result as ‘SQL Power’ using SQL ALIAS Column.

1 |
SELECT POWER(@i, 3) AS [SQL Powers] |

It means,

@i * @i * @i = 2 * 2 * 2 = 8

In the next statement, we used 4 as second argument. It means 2 * 2 * 2 * 2 = 16

1 |
SELECT POWER(@i, 4) AS [SQL Powers] |

In the next statement, We used the integer value as input for the POWER function.

1 2 3 |
-- Wrong Value SELECT POWER(@j, 3) AS [SQL Powers] SELECT POWER(2.20, 3) AS [SQL Powers] |

It means

POWER (@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

**NOTE:** Please use float variables as a input for POWER Function otherwise, you may expect strange results.

## SQL POWER Function Example 2

Power Function also allows you to calculate the power of column values. In this example, We are going to calculate the power of three for all the records present in [Sales Amount] using POWER Function.

**T-SQL CODE**

1 2 3 4 5 6 |
SELECT [EnglishProductName] ,[Color] ,[StandardCost] ,[SalesAmount] ,POWER([SalesAmount], 3) AS Sales FROM [Mathemetical Functions] |

**OUTPUT**

Thank You for Visiting Our Blog

## Leave a Reply