Consultes senzilles - Funcions Numèriques

Funcions Numèriques

• https://mariadb.com/kb/en/numeric-functions/

• Les més utilitzades són:

  • + - * / %

  • ABS, MOD

  • ROUND, TRUNCATE

  • CEILING, FLOOR

  • POW, SQRT

  • PI

Exemples de funcions

Exemples de funcions numèriques

SELECT 11 / 3, 11 % 3, MOD(11, 3);
SELECT ABS(-1),TRUNCATE(11/3,0),ROUND(11/3);
SELECT TRUNCATE(-1.3,0), ROUND(-1.3), FLOOR(-1.3);
SELECT PI();
SELECT SQRT(25), SQRT(2);
SELECT POW(2,10);

Exemples de funcions numèriques amb respostes

MariaDB [db]> SELECT 11 / 3, 11 % 3, MOD(11, 3);
+--------+--------+------------+
| 11 / 3 | 11 % 3 | MOD(11, 3) |
+--------+--------+------------+
| 3.6667 |      2 |          2 |
+--------+--------+------------+

MariaDB [db]> SELECT ABS(-1),TRUNCATE(11/3,0),ROUND(11/3);
+---------+------------------+-------------+
| ABS(-1) | TRUNCATE(11/3,0) | ROUND(11/3) |
+---------+------------------+-------------+
|       1 |                3 |           4 |
+---------+------------------+-------------+

MariaDB [db]> SELECT TRUNCATE(-1.3,0), ROUND(-1.3), FLOOR(-1.3);
+------------------+-------------+-------------+
| TRUNCATE(-1.3,0) | ROUND(-1.3) | FLOOR(-1.3) |
+------------------+-------------+-------------+
|               -1 |          -1 |          -2 |
+------------------+-------------+-------------+

MariaDB [db]> SELECT PI();
+----------+
| PI()     |
+----------+
| 3.141593 |
+----------+

MariaDB [db]> SELECT SQRT(25), SQRT(2);
+----------+--------------------+
| SQRT(25) | SQRT(2)            |
+----------+--------------------+
|        5 | 1.4142135623730951 |
+----------+--------------------+

MariaDB [db]> SELECT POW(2,10);
+-----------+
| POW(2,10) |
+-----------+
|      1024 |
+-----------+