🎴 Flashcard Mode
DB2 Administration and Oracle SQL Functions
Card1 / 20
Mastered0
Review0
QuestionClick to flip
select round(139.898,-2),round(188.898,-2) from dual would results in?
AnswerClick to flip back
A
100,200
💡 Explanation:
ROUND(number, -2) rounds to the hundreds place. ROUND(139.898, -2) = 100 (139 rounds down to 100). ROUND(188.898, -2) = 200 (188 rounds up to 200). The negative second parameter specifies the decimal place to round to - negative means left of decimal point.