表(TEACHER)包含以下列:
ID NUMBER(7) PK
SALARY NUMBER(7,2)
SUBJECT_ID NUMBER(7)
判断以下两个SQL语句:
(1)SELECT ROUND(SUM(salary),-2) FROM teacher ;
(2)SELECT subject_id, ROUND(SUM(salary),-2) FROM teacher GROUP BY subject_id ;
有什么不同结果? ( )
语句1将返回每个老师一个结果
语句2将返回多个结果
结果相同,显示不同
将有一个句子产生错误