Question

Write SQL query to add a column totalprice with data type numeric and size 10, 2 in a table product.

Answer 1

ALTER TABLE product
ADD totalprice NUMERIC(10, 2);