Question

which data type will be appropriate to store information as salary, fees, price etc.​

Answer 1

Answer:

double

Explanation:

double is more preferred than float as it provides double precision

Answer 2

Numeric Data

When declaring a decimal or numeric column, the precision and scale can be specified, such as decimal(p,s) or numeric(p,s), where p indicates the maximum total number of digits that can be stored to the left and right of the decimal point. The accuracy must be between 1 and 38. The standard level of precision is 18.

The s, or scale, defines the maximum number of digits that can be recorded to the right of the decimal point. Subtracting this amount from p yields the maximum number of digits to the left of the decimal point. The scale must be between 0 and p. By default, the scale is set to zero.