By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE access_action (
`ID` INTEGER AUTO_INCREMENT,
`ACTION` VARCHAR(25),
`TIMESTAMP` VARCHAR(21),
`level_id` INTEGER,
`EMPLOYEE_ID` INTEGER,
PRIMARY KEY (ID)
);
INSERT INTO access_action (ACTION, TIMESTAMP, level_id, EMPLOYEE_ID)
VALUES
('OUT', '2017-05-30 09:36:00', 3, 1),
('IN', '2017-05-30 09:26:00', 1, 1),
('OUT', '2017-05-30 08:46:00', 1, 1),
('IN', '2017-05-30 08:36:00', 3, 1),
('OUT', '2017-05-30 07:56:00', 2, 1),
('IN', '2017-05-30 07:46:00', 3, 1),
('OUT', '2017-05-30 07:06:00', 3, 1),
('IN', '2017-05-30 06:56:00', 1, 1),
('OUT', '2017-05-30 06:16:00', 2, 1),
('IN', '2017-05-30 06:06:00', 1, 1),
('OUT', '2017-05-29 08:55:00', 1, 1),
('IN', '2017-05-29 07:55:00', 1, 1),
('OUT', '2017-05-29 07:15:00', 1, 1),
('IN', '2017-05-29 07:05:00', 1, 1),
('OUT', '2017-05-29 06:25:00', 3, 1),
('IN', '2017-05-29 06:15:00', 1, 1),
('OUT', '2017-05-30 08:57:00', 1, 2),
('IN', '2017-05-30 08:37:00', 3, 2),
('OUT', '2017-05-30 07:57:00', 3, 2),
('IN', '2017-05-30 07:47:00', 2, 2),
('OUT', '2017-05-30 07:07:00', 3, 2),
('IN', '2017-05-30 06:57:00', 1, 2),
('OUT', '2017-05-30 06:17:00', 1, 2),
('IN', '2017-05-30 06:07:00', 1, 2),
('OUT', '2017-05-29 12:50:00', 2, 2),
('IN', '2017-05-29 12:01:00', 1, 2),
('OUT', '2017-05-29 11:21:00', 2, 2),
('IN', '2017-05-29 11:11:00', 3, 2),
('OUT', '2017-05-29 10:31:00', 3, 2),
('IN', '2017-05-29 10:21:00', 2, 2),
('OUT', '2017-05-29 09:41:00', 3, 2),
('IN', '2017-05-29 09:31:00', 3, 2),
SELECT * FROM access_action
ORDER BY EMPLOYEE_ID,level_id, `TIMESTAMP`
ID | ACTION | TIMESTAMP | level_id | EMPLOYEE_ID |
---|---|---|---|---|
16 | IN | 2017-05-29 06:15:00 | 1 | 1 |
14 | IN | 2017-05-29 07:05:00 | 1 | 1 |
13 | OUT | 2017-05-29 07:15:00 | 1 | 1 |
12 | IN | 2017-05-29 07:55:00 | 1 | 1 |
11 | OUT | 2017-05-29 08:55:00 | 1 | 1 |
10 | IN | 2017-05-30 06:06:00 | 1 | 1 |
8 | IN | 2017-05-30 06:56:00 | 1 | 1 |
3 | OUT | 2017-05-30 08:46:00 | 1 | 1 |
2 | IN | 2017-05-30 09:26:00 | 1 | 1 |
9 | OUT | 2017-05-30 06:16:00 | 2 | 1 |
5 | OUT | 2017-05-30 07:56:00 | 2 | 1 |
15 | OUT | 2017-05-29 06:25:00 | 3 | 1 |
7 | OUT | 2017-05-30 07:06:00 | 3 | 1 |
6 | IN | 2017-05-30 07:46:00 | 3 | 1 |
4 | IN | 2017-05-30 08:36:00 | 3 | 1 |
1 | OUT | 2017-05-30 09:36:00 | 3 | 1 |
26 | IN | 2017-05-29 12:01:00 | 1 | 2 |
24 | IN | 2017-05-30 06:07:00 | 1 | 2 |
23 | OUT | 2017-05-30 06:17:00 | 1 | 2 |
22 | IN | 2017-05-30 06:57:00 | 1 | 2 |
17 | OUT | 2017-05-30 08:57:00 | 1 | 2 |
30 | IN | 2017-05-29 10:21:00 | 2 | 2 |
27 | OUT | 2017-05-29 11:21:00 | 2 | 2 |
25 | OUT | 2017-05-29 12:50:00 | 2 | 2 |
20 | IN | 2017-05-30 07:47:00 | 2 | 2 |
32 | IN | 2017-05-29 09:31:00 | 3 | 2 |
31 | OUT | 2017-05-29 09:41:00 | 3 | 2 |
29 | OUT | 2017-05-29 10:31:00 | 3 | 2 |
28 | IN | 2017-05-29 11:11:00 | 3 | 2 |
21 | OUT | 2017-05-30 07:07:00 | 3 | 2 |
19 | OUT | 2017-05-30 07:57:00 | 3 | 2 |
18 | IN | 2017-05-30 08:37:00 | 3 | 2 |
60 | IN | 2017-05-29 06:13:00 | 1 | 3 |
58 | IN | 2017-05-29 07:03:00 | 1 | 3 |
54 | IN | 2017-05-29 08:43:00 | 1 | 3 |
49 | OUT | 2017-05-29 10:33:00 | 1 | 3 |
47 | OUT | 2017-05-29 11:43:00 | 1 | 3 |
46 | IN | 2017-05-30 06:12:00 | 1 | 3 |
43 | OUT | 2017-05-30 07:12:00 | 1 | 3 |
41 | OUT | 2017-05-30 08:02:00 | 1 | 3 |
34 | IN | 2017-05-30 11:12:00 | 1 | 3 |
33 | OUT | 2017-05-30 11:47:00 | 1 | 3 |
55 | OUT | 2017-05-29 08:03:00 | 2 | 3 |
52 | IN | 2017-05-29 09:33:00 | 2 | 3 |
51 | OUT | 2017-05-29 09:43:00 | 2 | 3 |
44 | IN | 2017-05-30 07:02:00 | 2 | 3 |
39 | OUT | 2017-05-30 08:52:00 | 2 | 3 |
37 | OUT | 2017-05-30 09:42:00 | 2 | 3 |
36 | IN | 2017-05-30 10:22:00 | 2 | 3 |
59 | OUT | 2017-05-29 06:23:00 | 3 | 3 |
57 | OUT | 2017-05-29 07:13:00 | 3 | 3 |
56 | IN | 2017-05-29 07:53:00 | 3 | 3 |
53 | OUT | 2017-05-29 08:53:00 | 3 | 3 |
50 | IN | 2017-05-29 10:23:00 | 3 | 3 |
48 | IN | 2017-05-29 11:13:00 | 3 | 3 |
45 | OUT | 2017-05-30 06:22:00 | 3 | 3 |
42 | IN | 2017-05-30 07:52:00 | 3 | 3 |
40 | IN | 2017-05-30 08:42:00 | 3 | 3 |
38 | IN | 2017-05-30 09:32:00 | 3 | 3 |
35 | OUT | 2017-05-30 10:32:00 | 3 | 3 |