一、原题
二、题目解析
ROUND(156.00,-1)
round表示四舍五入,-1表示保留到小数点左边一位,即十位,那么这里,ROUND(156.00,-1)=160
SQL> select ROUND(156.00,-1) from dual;
ROUND(156.00,-1)
----------------
160
Evaluate the following SQL query;
SQL> SELECT TRUNC(ROUND(156.00,-1),-1) FROM DUAL;
What would be the outcome?
A. 200
B. 16
C. 160
D. 150
E. 100
答案: C
SQL> SELECT TRUNC(ROUND(156.00,-1),-1) FROM DUAL;
What would be the outcome?
A. 200
B. 16
C. 160
D. 150
E. 100
答案: C
二、题目解析
ROUND(156.00,-1)
round表示四舍五入,-1表示保留到小数点左边一位,即十位,那么这里,ROUND(156.00,-1)=160
SQL> select ROUND(156.00,-1) from dual;
ROUND(156.00,-1)
----------------
160