Documentation Index
Fetch the complete documentation index at: https://private-7c7dfe99-page-updates.mintlify.app/llms.txt
Use this file to discover all available pages before exploring further.
groupArrayDistinct
Description
ThegroupArrayDistinct combinator
can be applied to the groupArray aggregate function to create an array
of distinct argument values.
Example usage
For this example we’ll make use of thehits dataset available in our SQL playground.
Imagine you want to find out, for each distinct landing page domain (URLDomain)
on your website, what are all the unique User Agent OS codes (OS) recorded for
visitors landing on that domain. This could help you understand the variety of
operating systems interacting with different parts of your site.