Question

Consider the decimal number x with value 8459.2654. Write commands in SQL
to
i) round it off to a whole number
ii)round it to 2 places before the decimal​

Answer 1

Answer:

a)There is a mathematical operation 2* 4.360. Here the answer is 8.72. Typically, the answer with regards to significant figures must be 8, since 2 has the least number of significant figures(No.of significant figures in 2=1). But the correct answer is 8.72. Please explain.

b) Is 3.00 considered to have 2 decimal places?(because of .00)

c) How do you round off a number by one decimal place?

Is this done by considering the digit after the number of decimal places to be rounded off?

Ex: In 1.02, do you consider2and write the answer as 1.0?

Answer 2

Answer:

answering just for free