MariaDB ROUND関数で小数点以下の四捨五入を行う方法
環境
MariaDB 10.6.4
Windows 10 Home 64bit
構文
ROUND( 値 )
四捨五入するには、「ROUND」を使用します。
使用例
1.数字の場合
SELECT ROUND( 3.4 ),ROUND( 5.5 ),ROUND( 6.1 ),ROUND( 7.9 )
SELECT ROUND( 3.4 ),ROUND( 5.5 ),ROUND( 6.1 ),ROUND( 7.9 )
SELECT ROUND( 3.4 ),ROUND( 5.5 ),ROUND( 6.1 ),ROUND( 7.9 )
実行結果
MariaDB [(none)]> SELECT ROUND( 3.4 ),ROUND( 5.5 ),ROUND( 6.1 ),ROUND( 7.9 );
+--------------+--------------+--------------+--------------+
| ROUND( 3.4 ) | ROUND( 5.5 ) | ROUND( 6.1 ) | ROUND( 7.9 ) |
+--------------+--------------+--------------+--------------+
| 3 | 6 | 6 | 8 |
+--------------+--------------+--------------+--------------+
1 row in set (0.134 sec)
MariaDB [(none)]> SELECT ROUND( 3.4 ),ROUND( 5.5 ),ROUND( 6.1 ),ROUND( 7.9 );
+--------------+--------------+--------------+--------------+
| ROUND( 3.4 ) | ROUND( 5.5 ) | ROUND( 6.1 ) | ROUND( 7.9 ) |
+--------------+--------------+--------------+--------------+
| 3 | 6 | 6 | 8 |
+--------------+--------------+--------------+--------------+
1 row in set (0.134 sec)
MariaDB [(none)]> SELECT ROUND( 3.4 ),ROUND( 5.5 ),ROUND( 6.1 ),ROUND( 7.9 ); +--------------+--------------+--------------+--------------+ | ROUND( 3.4 ) | ROUND( 5.5 ) | ROUND( 6.1 ) | ROUND( 7.9 ) | +--------------+--------------+--------------+--------------+ | 3 | 6 | 6 | 8 | +--------------+--------------+--------------+--------------+ 1 row in set (0.134 sec)
2.マイナスの場合
SQL構文
SELECT ROUND( -3.4 ),ROUND( -5.5 ),ROUND( -6.1 ),ROUND( -7.9 );
実行結果
MariaDB [(none)]> SELECT ROUND( -3.4 ),ROUND( -5.5 ),ROUND( -6.1 ),ROUND( -7.9 );
+---------------+---------------+---------------+---------------+
| ROUND( -3.4 ) | ROUND( -5.5 ) | ROUND( -6.1 ) | ROUND( -7.9 ) |
+---------------+---------------+---------------+---------------+
| -3 | -6 | -6 | -8 |
+---------------+---------------+---------------+---------------+
1 row in set (0.034 sec)
MariaDB [(none)]> SELECT ROUND( -3.4 ),ROUND( -5.5 ),ROUND( -6.1 ),ROUND( -7.9 );
+---------------+---------------+---------------+---------------+
| ROUND( -3.4 ) | ROUND( -5.5 ) | ROUND( -6.1 ) | ROUND( -7.9 ) |
+---------------+---------------+---------------+---------------+
| -3 | -6 | -6 | -8 |
+---------------+---------------+---------------+---------------+
1 row in set (0.034 sec)
MariaDB [(none)]> SELECT ROUND( -3.4 ),ROUND( -5.5 ),ROUND( -6.1 ),ROUND( -7.9 ); +---------------+---------------+---------------+---------------+ | ROUND( -3.4 ) | ROUND( -5.5 ) | ROUND( -6.1 ) | ROUND( -7.9 ) | +---------------+---------------+---------------+---------------+ | -3 | -6 | -6 | -8 | +---------------+---------------+---------------+---------------+ 1 row in set (0.034 sec)