Kandaanusha·Sep 1, 2025Explain ARRAY_AGG in SQLARRAY_AGG is an aggregate function in SQL that combines values from multiple rows into a single array. It's the inverse of a typical GROUP…
InDev GeniusbyFeng Li·Nov 24, 2023Object_construct: another exampleWe had some discussion in a previous post for how to construct table columns back to JSON file. We used object_construct and array_agg etc…
Suhas Thakral·Sep 28, 2023Find any Column in databaseIn the start of my career, I was constantly asking the senior people in my team , “where is this data” , which was like if I need to find…
