Примеры команд SQL в рамках урока #22

-- Функции SQL для числовых типов данных (ROUND, ABS, TRUNC)
-- https://youtu.be/m3ZeiBxkg70

-------------------------------------------
-- Примеры команд SQL в рамках урока #22


--ROUND
SELECT ROUND(123.456, 0) FROM DUAL;
SELECT ROUND(123.456, 1) FROM DUAL;
SELECT ROUND(123.456, 2) FROM DUAL;

--ABS
SELECT ABS(-5) FROM DUAL;
SELECT ABS(-5.6) FROM DUAL;
SELECT ABS(5.65) FROM DUAL;

--TRUNC
SELECT TRUNC(123.4567, 0) FROM DUAL;
SELECT TRUNC(123.4567, 1) FROM DUAL;
SELECT TRUNC(123.4567, 2) FROM DUAL;