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 Office Attendant 2026 Full Mock Test - 01

languageIcon English
  • pdpQsnIcon120 Questions
  • pdpsheetsIcon120 Marks
  • timerIcon90 Mins
languageIcon English
Free
Must Attempt
Video Solutions

RBI Office Attendant 2026: General English Section Test 01

languageIcon English
  • pdpQsnIcon30 Questions
  • pdpsheetsIcon30 Marks
  • timerIcon22 Mins
languageIcon English
Free
Must Attempt

RBI Office Attendant 2026: Quant Section Test 01

languageIcon English
  • pdpQsnIcon30 Questions
  • pdpsheetsIcon30 Marks
  • timerIcon23 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
341k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow