2015-09-17_12-58-02.txt

mysql> SELECT * FROM `salaries` where emp_no > 1000 LIMIT 11;
+--------+--------+------------+------------+
| emp_no | salary | from_date  | to_date    |
+--------+--------+------------+------------+
|  10001 |  60117 | 1986-06-26 | 1987-06-26 |
|  10001 |  62102 | 1987-06-26 | 1988-06-25 |
|  10001 |  66074 | 1988-06-25 | 1989-06-25 |
|  10001 |  66596 | 1989-06-25 | 1990-06-25 |
|  10001 |  66961 | 1990-06-25 | 1991-06-25 |
|  10001 |  71046 | 1991-06-25 | 1992-06-24 |
|  10001 |  74333 | 1992-06-24 | 1993-06-24 |
|  10001 |  75286 | 1993-06-24 | 1994-06-24 |
|  10001 |  75994 | 1994-06-24 | 1995-06-24 |
|  10001 |  76884 | 1995-06-24 | 1996-06-23 |
|  10001 |  80013 | 1996-06-23 | 1997-06-23 |
+--------+--------+------------+------------+
11 rows in set (0.01 sec)

mysql> SELECT * FROM `salaries` where emp_no > 5000 LIMIT 11;
+--------+--------+------------+------------+
| emp_no | salary | from_date  | to_date    |
+--------+--------+------------+------------+
|  10001 |  60117 | 1986-06-26 | 1987-06-26 |
|  10001 |  62102 | 1987-06-26 | 1988-06-25 |
|  10001 |  66074 | 1988-06-25 | 1989-06-25 |
|  10001 |  66596 | 1989-06-25 | 1990-06-25 |
|  10001 |  66961 | 1990-06-25 | 1991-06-25 |
|  10001 |  71046 | 1991-06-25 | 1992-06-24 |
|  10001 |  74333 | 1992-06-24 | 1993-06-24 |
|  10001 |  75286 | 1993-06-24 | 1994-06-24 |
|  10001 |  75994 | 1994-06-24 | 1995-06-24 |
|  10001 |  76884 | 1995-06-24 | 1996-06-23 |
|  10001 |  80013 | 1996-06-23 | 1997-06-23 |
+--------+--------+------------+------------+
11 rows in set (0.00 sec)

mysql> SELECT * FROM `salaries` where emp_no > 50000 LIMIT 11;
+--------+--------+------------+------------+
| emp_no | salary | from_date  | to_date    |
+--------+--------+------------+------------+
|  50001 |  58179 | 1987-08-28 | 1988-08-27 |
|  50001 |  59960 | 1988-08-27 | 1989-08-27 |
|  50001 |  60710 | 1989-08-27 | 1990-08-27 |
|  50001 |  63339 | 1990-08-27 | 1991-08-27 |
|  50001 |  67476 | 1991-08-27 | 1992-08-26 |
|  50001 |  69429 | 1992-08-26 | 1993-08-26 |
|  50001 |  69405 | 1993-08-26 | 1994-08-26 |
|  50001 |  70640 | 1994-08-26 | 1995-08-26 |
|  50001 |  70686 | 1995-08-26 | 1996-08-25 |
|  50001 |  73555 | 1996-08-25 | 1997-08-25 |
|  50001 |  76697 | 1997-08-25 | 1998-08-25 |
+--------+--------+------------+------------+
11 rows in set (0.01 sec)