blob: 7a72357070d620ef2751b21306a97959955ded7c (
plain) (
blame)
1
2
3
4
5
6
7
8
|
/* syntax version 1 */
select
Domain,
aggregate_list(AsStruct(DeviceID as DeviceID, DeviceCategory as DeviceCategory)) as Devices
from (
select 1 as DeviceID, 2 as DeviceCategory, 3 as Domain
)
group by Domain
|