hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    In SQL, what will be the output of the following query?
    Question



    In SQL, what will be the output of the following query?

    A.

    140

    B.

    150

    C.

    144

    D.

    145

    E.

    None of the above

    Correct option is A

    The ROUND function in SQL is used to round a numeric value to the specified precision.
    · The second argument, -1, specifies rounding to the nearest 10s place.
    · For 144.45:
    · The digit at the 10s place is 4.
    · Since the next digit (4) is less than 5, it is rounded down to 140.
    Important Key Points:
    1. The ROUND function takes two arguments:
    · The numeric value to be rounded.
    · The number of digits to which the value should be rounded (negative values indicate places left of the decimal).
    2. For positive numbers, a negative rounding position rounds to the left of the decimal point.
    Knowledge Booster:
    · ROUND(148.21, -1): Results in 150, as the next digit (8) is greater than or equal to 5.
    · ROUND(144.45, 1): Results in 144.5, rounding to one digit after the decimal.
    · ROUND(144.45, 0): Results in 144, rounding to the nearest integer.

    Free Tests

    Free
    Must Attempt

    DSSSB G-II/ASO Full Mock Test 1

    languageIcon English
    • pdpQsnIcon200 Questions
    • pdpsheetsIcon200 Marks
    • timerIcon120 Mins
    languageIcon English
    Free
    Must Attempt

    DSSSB ASO PYP (Held on 18 Aug 2025 S1)

    languageIcon English
    • pdpQsnIcon200 Questions
    • pdpsheetsIcon200 Marks
    • timerIcon120 Mins
    languageIcon English
    Free
    Must Attempt

    General Awareness Subject Test 1

    languageIcon English
    • pdpQsnIcon20 Questions
    • pdpsheetsIcon20 Marks
    • timerIcon10 Mins
    languageIcon English
    test-prime-package

    Access ‘IBPS RRB SO IT Officer (Scale-II)’ Mock Tests with

    • 60000+ Mocks and Previous Year Papers
    • Unlimited Re-Attempts
    • Personalised Report Card
    • 500% Refund on Final Selection
    • Largest Community
    students-icon
    383k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow