摘要: 平均 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 阅读全文
posted @ 2019-08-07 17:39 EricBlog 阅读(130) 评论(0) 推荐(0) 编辑
摘要: 查询语句 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 去 阅读全文
posted @ 2019-08-07 14:52 EricBlog 阅读(238) 评论(0) 推荐(0) 编辑