ExamVeda
Login
Home
This question belongs to SQL Sql Miscellaneous
Sql Miscellaneous
?

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.

Examveda
Question posted by Examveda
Community

Join the Discussion

3 Comments
Priyanka S
Priyanka S 5 years ago
round(45.926,-1) => will it give 46.0 or 50 ?
Then 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 ?
Drummer Sagar
Drummer Sagar 8 years ago
if plus 1 then
Harish Joshi
Harish Joshi 8 years ago
if the salary of all the employees is greater than the given condition than all the records will be display.
Ex: if all the employee salary is above 10000 and the condition is salary>8000 than all the records will be display.