摘要: #等值连接: 查询员工名和对应的部门名 mysql> select last_name,department_name from employees,departments where employees.department_id=departments.department_id; 查询员工名、 阅读全文
posted @ 2018-04-08 15:33 王毅2016 阅读(295) 评论(0) 推荐(0) 编辑
摘要: 常见函数: mysql> select sum(salary) from employees; + + | sum(salary) | + + | 691400.00 | + + 1 row in set (0.00 sec) mysql> select avg(salary) from emplo 阅读全文
posted @ 2018-04-08 14:39 王毅2016 阅读(506) 评论(0) 推荐(0) 编辑