 GeeksforGeeks App
Open App Browser
Continue

# POWER(), SUM() and PI() Function in MariaDB

1. POWER() Function :
In MariaDB, the POWER() function is used to returns m raised to the nth power. In this function, two parameters will be passed first will be m (Numeric). It is the base used in the calculation, and the second will be n (Numeric). It is the exponent used in the calculation.

Syntax :

`POWER(m, n)`

Returns : Value of m raised to the nth power.

Table – IPL

Team_idTeamnameScore</tdh
1RR140
2CSK210
3MI160
4DC170

Example-1 :

```SELECT POWER(Score) AS POWER_Score
FROM IPL
WHERE Teamname='CSK';```

Output :

POWER_Score
44100

Example-2 :

`SELECT (POWER(7, 2) - POWER(2, 4)) AS POWER_VALUE;`

Output :

POWER_VALUE
33

Example-3 :

`SELECT (POWER(10, 0) * POWER(2, 3)) AS POWER_VALUE;`

Output :

POWER_VALUE
8

2. SUM() Function :
In MariaDB, the SUM() function is used to return the summed value of an expression. In this function, aggregate_expression or multiple expressions will be passed, which will return a result. It works like sum function in the processed query. An aggregate_expression will be pass as a parameter and it will return the summed value of the expression. NULL values are ignored.

Syntax :

```SELECT SUM(aggregate_expression)
FROM tables
[WHERE conditions];```

Returns : The summed value of an expression.

Example-1 :

```SELECT SUM(Score) AS TOTAL_Score
FROM IPL;```

Output :

TOTAL_Score
680

Example-2 :

```SELECT (SUM(Score) + 100) AS TOTAL_Score
FROM IPL
WHERE Score<200;```

Output :

TOTAL_Score
570

Example-3 :

```SELECT (SUM(Score) * 2) AS TOTAL_Score
FROM IPL
WHERE Score>170;```

Output :

TOTAL_Score
340

3. PI() Function :
In MariaDB, the PI() Function used to return the value of π (pi) displayed upto 6 decimal places. In this function, no parameter will be passed and it will return the value of pi. It uses the double-precision value when it will be used in calculations with other double-precision values. It displays value up to only 6 decimal places.

Syntax :

`PI( )`

Returns : The value of π (pi) upto 6 decimal places.

Example-1 :

`SELECT PI();`

Output :

`3.141593`

Example-2 :

`SELECT PI()*3.000000000000000;`

Output :

`9.424777960769380`

Example-3 :

`SELECT PI()+5;`

Output :

` 8.141593`
My Personal Notes arrow_drop_up