?
The SQL statement
The SQL statement
SELECT ROUND(45.926, -1) FROM DUAL;
Answer & Solution
Correct Answer:
Option
D
The ROUND function in SQL is used to round a number to a specified precision. The syntax is:
ROUND (expression, [decimal place])
where [decimal place] indicates the number of decimal points returned. A negative number means the rounding will occur to the digit to the left of the decimal point. For example, -1 means the number will be rounded to the nearest tens.
For above given example, the output would be 50 because the nearest tens of 45.926, is 50.
Taking another example, if we have to round (44.678, -1), the out put would be 40, because the nearest tens of 44.678 is 40.
Join the Discussion
Login to post a comment or share your explanation.
LoginThen what will round(49.926,-1) will give ?
Iam a bit confused of the way it is performing, can anyone give any clarifications reg this ?
Ex: if all the employee salary is above 10000 and the condition is salary>8000 than all the records will be display.