QueryStash
1SELECT 2 id, 3 name, 4 ARRAY_AGG( 5 STRUCT( 6 address, 7 from_date, 8 to_date, 9 ) ORDER BY to_date DESC 10 ) AS address_history 11FROM customers 12GROUP BY 1,2
Created: Jan 12th 2023
Made with ❤️ by @Yekalb
© 2024 Query Stash. All rights reserved
Resources
Examples
Stay up to date