Compare the output of the following: SELECT TRUNC(99.57,1) FROM DUAL; and SELECT ROUND(99.57,1) FROM DUAL;
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- SELECT ROUND(123.456,2) , TRUNC(123.456,2), ROUND(125.456, -1) , TRUNC(126.456,-2) FROM DUAL;
- Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?
- Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?
- Evaluate the given SQL statement. SELECT ROUND (45.953, -1), TRUNC (45.936, 2) FROM dual; Which of the foll...
- SELECT TRUNC(1234.5678,-2) FROM DUAL;
- What would be the output of the following SQL query? SQL>select trunc(19.989776,1) from dual;
- What is the output of the following? SELECT ROUND(1111.93412,3) FROM DUAL;
- What is the output of the following? SELECT ROUND(1111.93412,3) FROM DUAL;