Pagination en sql ($7) · Snippets · GitLab

Romain Bonnal 🥑 @Romain · Aug 03, 2023

SELECT STRING_AGG(entity_id::text, ',') AS concatenated_ids FROM ( SELECT entity_id FROM public.raw_maxxton_event WHERE entity_type = 'CUSTOMER' AND entity_action IN ('INSERT', 'UPDATE', 'MERGE') AND date >= '2023-01-01' AND date < '2023-08-01'
GROUP BY entity_id ORDER BY entity_id LIMIT 5 ) AS subquery;

SELECT STRING_AGG(entity_id::text, ',') AS concatenated_ids FROM ( SELECT entity_id FROM public.raw_maxxton_event WHERE entity_type = 'CUSTOMER' AND entity_action IN ('INSERT', 'UPDATE', 'MERGE') AND date >= '2023-01-01' AND date < '2023-08-01' GROUP BY entity_id ORDER BY entity_id LIMIT 5 ) AS subquery;

Please register or to comment