Time Is Song

摘要： #等值连接： 查询员工名和对应的部门名 mysql> select last_name,department_name from employees,departments where employees.department_id=departments.department_id; 查询员工名、 阅读全文

摘要： 常见函数： mysql> select sum(salary) from employees; + + | sum(salary) | + + | 691400.00 | + + 1 row in set (0.00 sec) mysql> select avg(salary) from emplo 阅读全文