Salaries

Displaying query for 100 employee with their salary at a selected point in time.

select `employees`.`emp_no`,`employees`.`first_name`,`employees`.`last_name`,`employees`.`hire_date`,`_s`.`salary`,`_s`.`from_date` `salary_from_date`,`_s`.`to_date` `salary_to_date` from `employees` inner join `salaries` as `_s` on `_s`.`emp_no` = `employees`.`emp_no` where `_s`.`from_date` <= "2017-05-25" and `_s`.`to_date` >= "2017-05-25" limit 0, 100 [:a_2, :a]
Emp No First Name Last Name Hire Date Salary Salary From Date Salary To Date Edit Delete
10002 Bezalel Simmel 21/11/1985 72527 02/08/2001 01/01/9999
10004 Chirstian Koblick 01/12/1986 74057 27/11/2001 01/01/9999
10006 Anneke Preusig 02/06/1989 59755 02/08/2001 01/01/9999
10007 Tzvetan Zielinski 10/02/1989 88070 07/02/2002 01/01/9999