Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* return highest salary, employee name, deparment name for each department */
- /*
- +----------------------+
- | Tables_in_employees |
- +----------------------+
- | current_dept_emp |
- | departments |
- | dept_emp |
- | dept_emp_latest_date |
- | dept_manager |
- | employees |
- | salaries |
- | titles |
- +----------------------+
- mysql> desc dept_emp;
- +-----------+---------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +-----------+---------+------+-----+---------+-------+
- | emp_no | int(11) | NO | PRI | NULL | |
- | dept_no | char(4) | NO | PRI | NULL | |
- | from_date | date | NO | | NULL | |
- | to_date | date | NO | | NULL | |
- +-----------+---------+------+-----+---------+-------+
- mysql> desc departments;
- +-----------+-------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +-----------+-------------+------+-----+---------+-------+
- | dept_no | char(4) | NO | PRI | NULL | |
- | dept_name | varchar(40) | NO | UNI | NULL | |
- +-----------+-------------+------+-----+---------+-------+
- mysql> desc employees;
- +------------+---------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +------------+---------------+------+-----+---------+-------+
- | emp_no | int(11) | NO | PRI | NULL | |
- | birth_date | date | NO | | NULL | |
- | first_name | varchar(14) | NO | | NULL | |
- | last_name | varchar(16) | NO | | NULL | |
- | gender | enum('M','F') | NO | | NULL | |
- | hire_date | date | NO | | NULL | |
- +------------+---------------+------+-----+---------+-------+\
- mysql> desc salaries;
- +-----------+---------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +-----------+---------+------+-----+---------+-------+
- | emp_no | int(11) | NO | PRI | NULL | |
- | salary | int(11) | NO | | NULL | |
- | from_date | date | NO | PRI | NULL | |
- | to_date | date | NO | | NULL | |
- +-----------+---------+------+-----+---------+-------+
- */
Add Comment
Please, Sign In to add comment