宗学唯zi

摘要： --绝对值select abs(-100) from dual;--取余select mod(8 ,3) from dual;--上限值select ceil (12.5) from dual;--下限值select floor (12.5) from dual;--四舍五入select round... 阅读全文

摘要： --12.select CNO,count(1) as 数量,avg(DEGREE) as 平均值 from T_HQ_SCORE where CNO like '3%'group by CNO having count(1) >=5;--13.select SNO from T_HQ_SCORE... 阅读全文