SQL constraint minvalue / maxvalue?

Question

Is there a way to set a SQL constraint for a numeric field that min value should be 1234 and max value should be 4523?

user_1579356 · Answer

FYI

When you need a constraint for a range of values:

ALTER TABLE package_subscription ADD CONSTRAINT check_discount_amount CHECK (discount_amount BETWEEN 0.0000 AND 1.0000);