Eric

摘要： 平均 svg select avg(sal + IFNULL(comm,0)) as avg_sal from t_emp 总和 sum select sum(sal + IFNULL(comm,0)) as sum_sal from t_emp 最大 max select max(sal + IF 阅读全文

摘要： 查询语句 select * from t_deptselect empno,ename,sal from t_emp select empno, sal * 12 as "income" from t_emp 分页 select empno,ename from t_emp limit 10,5 去 阅读全文