sql decimal(18 0)
-- DECIMAL(p,s) p: number of digits (lkeft+right) s: number of digits (right)
-- NUMERIC and DECIMAL are synonyms
CREATE TABLE test.sql_decimal (
dec_col DECIMAL (4, 2) -- Max total 4 digits, including 2 after decimal
);
INSERT INTO test.sql_decimal (dec_col) VALUES (10.05); -- OK 4 digits
INSERT INTO test.sql_decimal (dec_col) VALUES (21.0425); -- KO