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
    Video Solutions

    RBI Assistant Pre 2026 Full Mock Test -01

    languageIcon English
    • pdpQsnIcon100 Questions
    • pdpsheetsIcon100 Marks
    • timerIcon60 Mins
    languageIcon English
    Free
    Must Attempt
    Video Solutions

    RBI Asst Prelims 2026 : Reasoning Section Test 01

    languageIcon English
    • pdpQsnIcon35 Questions
    • pdpsheetsIcon35 Marks
    • timerIcon20 Mins
    languageIcon English
    Free
    Must Attempt
    Video Solutions

    RBI Office Attendant 2026 Full Mock Test - 01

    languageIcon English
    • pdpQsnIcon120 Questions
    • pdpsheetsIcon120 Marks
    • timerIcon90 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
    354k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow