[MySQL] Round(), FLOOR(), CEIL()

[반올림] Round()

SELECT d.name, ROUND(AVG(income)) AS `부서별 최저연봉`
FROM emp AS e
INNER JOIN dept AS d
ON e.deptId = d.id
GROUP BY deptId;

 

[버림] FLOOR()

SELECT d.name, FLOOR(AVG(income)) AS `부서별 최저연봉`
FROM emp AS e
INNER JOIN dept AS d
ON e.deptId = d.id
GROUP BY deptId;

 

[올림] CEIL()

SELECT d.name, CEIL(AVG(income)) AS `부서별 최저연봉`
FROM emp AS e
INNER JOIN dept AS d
ON e.deptId = d.id
GROUP BY deptId;