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.
version()
8.0.18
camtimestamp camname
2019-12-31 00:47:04 wls1
2019-12-31 04:57:41 wls2
2019-12-31 05:15:22 wls1
2019-12-31 05:35:00 wls2
2019-12-31 05:46:56 wls1
2019-12-31 05:51:30 wls2
2019-12-31 05:54:19 wls1
2019-12-31 05:56:14 wls2
2019-12-31 05:58:45 wls1
2019-12-31 05:58:46 wls2
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fiddle_UWYVAYCIMYZSHLDRVNYP.event.camtimestamp' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by