Skip to content

Instantly share code, notes, and snippets.

@SupaHam

SupaHam/2015-09-17_12-58-02.txt Secret

Created September 17, 2015 11:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save SupaHam/8ef2fc07ad2976222a79 to your computer and use it in GitHub Desktop.
Save SupaHam/8ef2fc07ad2976222a79 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment