add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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