dept_emp_latest_date
Documentation | Employees (MySQL database) |
Name | dept_emp_latest_date |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | emp_no | int(10, 0) | Employee identification number. | |||||
Employee identification number. |
||||||||
2 | from_date | date | Date the employee started work in the department. | |||||
Date the employee started work in the department. |
||||||||
3 | to_date | date | Date the employee left the department. | |||||
Date the employee left the department. |
Script
select `employees`.`dept_emp`.`emp_no` AS `emp_no`,max(`employees`.`dept_emp`.`from_date`) AS `from_date`,max(`employees`.`dept_emp`.`to_date`) AS `to_date` from `employees`.`dept_emp` group by `employees`.`dept_emp`.`emp_no` |
Exported: 2018-11-09 14:32, Last imported: 2018-08-06 09:21