add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id machine_no emp_card_no flag punch_date punch_time day month year r_code mflag
20547 01 00000009 F 2020-12-30 08:28:22 08:28:22 30 12 2020
20551 01 00000005 F 2020-12-30 09:43:28 09:43:28 30 12 2020
20559 01 00000009 F 2020-12-30 13:52:13 13:52:13 30 12 2020
20561 01 00000005 F 2020-12-30 14:26:01 14:26:01 30 12 2020
20563 01 00000005 F 2020-12-30 14:48:51 14:48:51 30 12 2020
20564 01 00000009 F 2020-12-30 15:34:33 15:34:33 30 12 2020
20566 01 00000005 F 2020-12-30 18:21:56 18:21:56 30 12 2020
20569 01 00000009 F 2020-12-30 18:47:06 18:47:06 30 12 2020
id machine_no emp_card_no flag punch_date punch_time day month year r_code mflag delta dummy
20551 01 00000005 F 2020-12-30 09:43:28 09:43:28 30 12 2020 null 2020-12-30 09:43:28
20561 01 00000005 F 2020-12-30 14:26:01 14:26:01 30 12 2020 16953 null
20563 01 00000005 F 2020-12-30 14:48:51 14:48:51 30 12 2020 null 2020-12-30 14:48:51
20566 01 00000005 F 2020-12-30 18:21:56 18:21:56 30 12 2020 12785 null
20547 01 00000009 F 2020-12-30 08:28:22 08:28:22 30 12 2020 null 2020-12-30 08:28:22
20559 01 00000009 F 2020-12-30 13:52:13 13:52:13 30 12 2020 19431 null
20564 01 00000009 F 2020-12-30 15:34:33 15:34:33 30 12 2020 null 2020-12-30 15:34:33
20569 01 00000009 F 2020-12-30 18:47:06 18:47:06 30 12 2020 11553 null
machine_no emp_card_no punch_date spent
01 00000005 2020-12-30 29738
01 00000009 2020-12-30 30984