Menu
Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. The SQL statement
    SELECT ROUND(45.926, -1) FROM DUAL;

    2. A.

     is illegal
    B.

     prints garbage
    C.

     prints 045.926
    D.

     prints 50

    View Answer

    Workspace

    View Answer

    Answer : Option D

    Explanation :

    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.

Write your comments here:

Be The First To Comment