摘要: #查询员工号为176的员工的姓名和部门号和年薪 USE myemployees; SELECT last_name, `manager_id`, `salary`*12*(1+IFNULL(`commission_pct`,0)) FROM employees WHERE `employee_id` 阅读全文
posted @ 2020-04-23 15:06 亚斯娜 阅读(145) 评论(0) 推荐(0)