숫자 관련 함수

ABS(숫자)

CEILING(숫자)

FLOOR(숫자)

ROUND(숫자, 자릿수)

TRUNCATE(숫자, 자릿수)

POW(숫자, n)

MOD(분자, 분모)

GREATEST(숫자1, 숫자2, 숫자3 ...)

LEAST(숫자1, 숫자2, 숫자3 ...)

SELECT ABS(-5);

SELECT CEILING(4.6);

SELECT CEILING(-4.6);

SELECT FLOOR(4.789);

SELECT FLOOR(-4.789);

SELECT ROUND(4.567, 2);

SELECT ROUND(-4.567, -2);

SELECT ROUND(4567, -2);

SELECT TRUNCATE(4.567, 2);

SELECT TRUNCATE(-4.567, 2);

SELECT TRUNCATE(4567, -2);

SELECT POW(2, 3);

SELECT MOD(15, 4);

SELECT GREATEST(15, 4, 21, 7);

SELECT LEAST(15, 4, 21, 7);