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` <= "2019-08-19" and `_s`.`to_date` >= "2019-08-19" limit 0, 100 [:a_2, :a]
Emp No First Name Last Name Hire Date Salary Salary From Date Salary To Date Edit Delete
10007 Tzvetan Zielinski 10/02/1989 88070 07/02/2002 01/01/9999
10010 Duangkaew Piveteau 24/08/1989 80324 23/11/2001 01/01/9999
10013 Eberhardt Terkki 20/10/1985 68901 16/10/2001 01/01/9999
10014 Berni Genin 11/03/1987 60598 27/12/2001 01/01/9999
10016 Kazuhito Cappelletti 27/01/1995 77935 10/02/2002 01/01/9999
10018 Kazuhide Peha 03/04/1987 84672 30/03/2002 01/01/9999
10019 Lillian Haddadi 30/04/1999 50032 29/04/2002 01/01/9999
10020 Mayuko Warwick 26/01/1991 47017 29/12/2001 01/01/9999
10022 Shahaf Famili 22/08/1995 41348 02/09/2001 01/01/9999
10023 Bojan Montemayor 17/12/1989 50113 26/09/2001 01/01/9999
10024 Suzette Pettey 19/05/1997 96646 13/06/2002 01/01/9999
10026 Yongqiao Berztiss 20/03/1995 66313 18/03/2002 01/01/9999
10027 Divier Reistad 07/07/1989 46145 31/03/2002 01/01/9999
10029 Otmar Herbst 20/11/1985 77777 15/09/2001 01/01/9999
10030 Elvis Demeyer 17/02/1994 88806 15/02/2002 01/01/9999
10031 Karsten Joslin 01/09/1991 56689 29/08/2001 01/01/9999
10032 Jeong Reistad 20/06/1990 69539 17/06/2002 01/01/9999
10035 Alain Chappelet 05/09/1988 68755 02/09/2001 01/01/9999
10036 Adamantios Portugali 03/01/1992 63053 26/04/2002 01/01/9999
10037 Pradeep Makrucki 05/12/1990 60574 <