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