Evaluate the following SQL query; What would be the outcome?
A.
16
B.
100
C.
200
D.
160
E.
150
What would be the outcome?
Evaluate the following SQL query; What would be the outcome?
Leave a Reply
Evaluate the following SQL query; What would be the outcome?
Evaluate the following SQL query; What would be the outcome?
A.
16
B.
100
C.
200
D.
160
E.
150
Tests:
SELECT ROUND(156.00) FROM DUAL;
ROUND(156.00)
—————————————
156
SELECT ROUND(156.00,-1) FROM DUAL;
ROUND(156.00,-1)
—————————————
160
SELECT TRUNC(ROUND(156.00,-1),-1) FROM DUAL;
TRUNC(ROUND(156.00,-1),-1)
—————————————
160