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.
Records: 14  Duplicates: 0  Warnings: 0
lag_1 created_date lead_1 f_val c_f_diff min_diff ut_d o_url c_sess_id
null 2021-01-18 10:30:24.00 2021-01-18 12:57:24.00 2021-01-18 10:30:24.00 0.00 147 -8820.00 https://zendes.com/ znkjoc3gfth2c3m0t1klii
null 2021-01-18 11:02:24.00 2021-01-18 11:02:35.00 2021-01-18 11:02:24.00 0.00 0 -11.00 https://zes.com/ znkjoc
2021-01-18 11:02:24.00 2021-01-18 11:02:35.00 2021-01-18 11:03:03.00 2021-01-18 11:02:24.00 11.00 0 -28.00 https://zes.com/ znkjoc
2021-01-18 11:02:35.00 2021-01-18 11:03:03.00 2021-01-18 11:04:15.00 2021-01-18 11:02:24.00 39.00 1 -72.00 https://zes.com/ znkjoc
2021-01-18 11:03:03.00 2021-01-18 11:04:15.00 2021-01-18 11:04:30.00 2021-01-18 11:02:24.00 111.00 0 -15.00 https://zes.com/ znkjoc
2021-01-18 11:04:15.00 2021-01-18 11:04:30.00 null 2021-01-18 11:02:24.00 126.00 null null https://zes.com/ znkjoc
null 2021-01-18 11:49:28.00 2021-01-18 11:49:48.00 2021-01-18 11:49:28.00 0.00 0 -20.00 https://rararar.com/ znkjoc3gfth2c3m0t1klii
2021-01-18 11:49:28.00 2021-01-18 11:49:48.00 2021-01-18 11:50:13.00 2021-01-18 11:49:28.00 20.00 0 -25.00 https://rararar.com/ znkjoc3gfth2c3m0t1klii
2021-01-18 11:49:48.00 2021-01-18 11:50:13.00 null 2021-01-18 11:49:28.00 45.00 null null https://rararar.com/ znkjoc3gfth2c3m0t1klii
2021-01-18 10:30:24.00 2021-01-18 12:57:24.00 null 2021-01-18 10:30:24.00 8820.00 null null https://zendes.com/ znkjoc3gfth2c3m0t1klii
null 2021-02-18 09:02:24.00 2021-02-18 09:02:35.00 2021-02-18 09:02:24.00 0.00 0 -11.00 https://rar.com/ znkjoc3
2021-02-18 09:02:24.00 2021-02-18 09:02:35.00 2021-02-18 09:03:03.00 2021-02-18 09:02:24.00 11.00 0 -28.00 https://rar.com/ znkjoc3
2021-02-18 09:02:35.00 2021-02-18 09:03:03.00 2021-02-18 09:04:15.00 2021-02-18 09:02:24.00 39.00 1 -72.00 https://rar.com/ znkjoc3
2021-02-18 09:03:03.00 2021-02-18 09:04:15.00 null 2021-02-18 09:02:24.00 111.00 null null https://rar.com/ znkjoc3
fv lv lag_1 created_date lead_1 XXX YYY testy c_f_diff min_diff ut_d o_url c_sess_id
2021-01-18 10:30:24.00 2021-01-18 10:30:24.00 null 2021-01-18 10:30:24.00 2021-01-18 12:57:24.00 8820.00 null 1 0.00 147 -8820.00 https://zendes.com/ znkjoc3gfth2c3m0t1klii
2021-01-18 11:02:24.00 2021-01-18 11:02:24.00 null 2021-01-18 11:02:24.00 2021-01-18 11:02:35.00 11.00 null 1 0.00 0 -11.00 https://zes.com/ znkjoc
2021-01-18 11:02:24.00 2021-01-18 11:02:35.00 2021-01-18 11:02:24.00 2021-01-18 11:02:35.00 2021-01-18 11:03:03.00 28.00 11.00 0 11.00 0 -28.00 https://zes.com/ znkjoc
2021-01-18 11:02:24.00 2021-01-18 11:03:03.00 2021-01-18 11:02:35.00 2021-01-18 11:03:03.00 2021-01-18 11:04:15.00 72.00 28.00 0 39.00 1 -72.00 https://zes.com/ znkjoc
2021-01-18 11:02:24.00 2021-01-18 11:04:15.00 2021-01-18 11:03:03.00 2021-01-18 11:04:15.00 2021-01-18 11:04:30.00 15.00 72.00 0 111.00 0 -15.00 https://zes.com/ znkjoc
2021-01-18 11:02:24.00 2021-01-18 11:04:30.00 2021-01-18 11:04:15.00 2021-01-18 11:04:30.00 null null 15.00 0 126.00 null null https://zes.com/ znkjoc
2021-01-18 11:49:28.00 2021-01-18 11:49:28.00 null 2021-01-18 11:49:28.00 2021-01-18 11:49:48.00 20.00 null 1 0.00 0 -20.00 https://rararar.com/ znkjoc3gfth2c3m0t1klii
2021-01-18 11:49:28.00 2021-01-18 11:49:48.00 2021-01-18 11:49:28.00 2021-01-18 11:49:48.00 2021-01-18 11:50:13.00 25.00 20.00 0 20.00 0 -25.00 https://rararar.com/ znkjoc3gfth2c3m0t1klii
2021-01-18 11:49:28.00 2021-01-18 11:50:13.00 2021-01-18 11:49:48.00 2021-01-18 11:50:13.00 null null 25.00 0 45.00 null null https://rararar.com/ znkjoc3gfth2c3m0t1klii
2021-01-18 10:30:24.00 2021-01-18 12:57:24.00 2021-01-18 10:30:24.00 2021-01-18 12:57:24.00 null null 8820.00 1 8820.00 null null https://zendes.com/ znkjoc3gfth2c3m0t1klii
2021-02-18 09:02:24.00 2021-02-18 09:02:24.00 null 2021-02-18 09:02:24.00 2021-02-18 09:02:35.00 11.00 null 1 0.00 0 -11.00 https://rar.com/ znkjoc3
2021-02-18 09:02:24.00 2021-02-18 09:02:35.00 2021-02-18 09:02:24.00 2021-02-18 09:02:35.00 2021-02-18 09:03:03.00 28.00 11.00 0 11.00 0 -28.00 https://rar.com/ znkjoc3
2021-02-18 09:02:24.00 2021-02-18 09:03:03.00 2021-02-18 09:02:35.00 2021-02-18 09:03:03.00 2021-02-18 09:04:15.00 72.00 28.00 0 39.00 1 -72.00 https://rar.com/ znkjoc3
2021-02-18 09:02:24.00 2021-02-18 09:04:15.00 2021-02-18 09:03:03.00 2021-02-18 09:04:15.00 null null 72.00 0 111.00 null null https://rar.com/ znkjoc3
created_date YYY s rn st fv lv o_url c_sess_id
2021-01-18 10:30:24.00 null 1 1 1 2021-01-18 10:30:24.00 2021-01-18 10:30:24.00 https://zendes.com/ znkjoc3gfth2c3m0t1klii
2021-01-18 11:02:24.00 null 2 2 2 2021-01-18 10:30:24.00 2021-01-18 11:02:24.00 https://zes.com/ znkjoc
2021-01-18 11:02:35.00 11.00 0 1 2 2021-01-18 11:02:35.00 2021-01-18 11:02:35.00 https://zes.com/ znkjoc
2021-01-18 11:03:03.00 28.00 0 2 2 2021-01-18 11:02:35.00 2021-01-18 11:03:03.00 https://zes.com/ znkjoc
2021-01-18 11:04:15.00 72.00 0 3 2 2021-01-18 11:02:35.00 2021-01-18 11:04:15.00 https://zes.com/ znkjoc
2021-01-18 11:04:30.00 15.00 0 4 2 2021-01-18 11:02:35.00 2021-01-18 11:04:30.00 https://zes.com/ znkjoc
2021-01-18 11:49:28.00 null 3 3 3 2021-01-18 10:30:24.00 2021-01-18 11:49:28.00 https://rararar.com/ znkjoc3gfth2c3m0t1klii
2021-01-18 11:49:48.00 20.00 0 5 3 2021-01-18 11:02:35.00 2021-01-18 11:49:48.00 https://rararar.com/ znkjoc3gfth2c3m0t1klii
2021-01-18 11:50:13.00 25.00 0 6 3 2021-01-18 11:02:35.00 2021-01-18 11:50:13.00 https://rararar.com/ znkjoc3gfth2c3m0t1klii
2021-01-18 12:57:24.00 8820.00 4 4 4 2021-01-18 10:30:24.00 2021-01-18 12:57:24.00 https://zendes.com/ znkjoc3gfth2c3m0t1klii
2021-02-18 09:02:24.00 null 5 5 5 2021-01-18 10:30:24.00 2021-02-18 09:02:24.00 https://rar.com/ znkjoc3
2021-02-18 09:02:35.00 11.00 0 7 5 2021-01-18 11:02:35.00 2021-02-18 09:02:35.00 https://rar.com/ znkjoc3
2021-02-18 09:03:03.00 28.00 0 8 5 2021-01-18 11:02:35.00 2021-02-18 09:03:03.00 https://rar.com/ znkjoc3
2021-02-18 09:04:15.00 72.00 0 9 5 2021-01-18 11:02:35.00 2021-02-18 09:04:15.00 https://rar.com/ znkjoc3
sid created_date st min_cd max_cd f_ts l_ts c_ts_asc c_ts_desc o_url c_sess_id
1 2021-01-18 10:30:24.00 1 2021-01-18 10:30:24.00 2021-01-18 10:30:24.00 1 1 1 1 https://zendes.com/ znkjoc3gfth2c3m0t1klii
2 2021-01-18 11:02:24.00 2 2021-01-18 11:02:24.00 2021-01-18 11:04:30.00 1 5 1 5 https://zes.com/ znkjoc
3 2021-01-18 11:02:35.00 2 2021-01-18 11:02:24.00 2021-01-18 11:04:30.00 2 4 2 4 https://zes.com/ znkjoc
4 2021-01-18 11:03:03.00 2 2021-01-18 11:02:24.00 2021-01-18 11:04:30.00 3 3 3 3 https://zes.com/ znkjoc
5 2021-01-18 11:04:15.00 2 2021-01-18 11:02:24.00 2021-01-18 11:04:30.00 4 2 4 2 https://zes.com/ znkjoc
50 2021-01-18 11:04:30.00 2 2021-01-18 11:02:24.00 2021-01-18 11:04:30.00 5 1 5 1 https://zes.com/ znkjoc
6 2021-01-18 11:49:28.00 3 2021-01-18 11:49:28.00 2021-01-18 11:50:13.00 1 3 1 3 https://rararar.com/ znkjoc3gfth2c3m0t1klii
7 2021-01-18 11:49:48.00 3 2021-01-18 11:49:28.00 2021-01-18 11:50:13.00 2 2 2 2 https://rararar.com/ znkjoc3gfth2c3m0t1klii
8 2021-01-18 11:50:13.00 3 2021-01-18 11:49:28.00 2021-01-18 11:50:13.00 3 1 3 1 https://rararar.com/ znkjoc3gfth2c3m0t1klii
9 2021-01-18 12:57:24.00 4 2021-01-18 12:57:24.00 2021-01-18 12:57:24.00 1 1 1 1 https://zendes.com/ znkjoc3gfth2c3m0t1klii
10 2021-02-18 09:02:24.00 5 2021-02-18 09:02:24.00 2021-02-18 09:04:15.00 1 4 1 4 https://rar.com/ znkjoc3
11 2021-02-18 09:02:35.00 5 2021-02-18 09:02:24.00 2021-02-18 09:04:15.00 2 3 2 3 https://rar.com/ znkjoc3
12 2021-02-18 09:03:03.00 5 2021-02-18 09:02:24.00 2021-02-18 09:04:15.00 3 2 3 2 https://rar.com/ znkjoc3
13 2021-02-18 09:04:15.00 5 2021-02-18 09:02:24.00 2021-02-18 09:04:15.00 4 1 4 1 https://rar.com/ znkjoc3
sid Session no. Start of sessions End of sessions Session count o_url c_sess_id
2 2 2021-01-18 11:02:24.00 2021-01-18 11:04:30.00 5 https://zes.com/ znkjoc
10 5 2021-02-18 09:02:24.00 2021-02-18 09:04:15.00 4 https://rar.com/ znkjoc3
rn st sids URL: Session id: Session start time: Session end time:
1 2 2,3,4,5,50 https://zes.com/ znkjoc 2021-01-18 11:02:24.00 2021-01-18 11:04:30.00
2 5 10,11,12,13 https://rar.com/ znkjoc3 2021-02-18 09:02:24.00 2021-02-18 09:04:15.00