◀ Back to Playground Home

Find the documents that have the longest string arrays in a multi value column

select ARRAYLENGTH(string_mv_field), string_mv_field
from users 
order by ARRAYLENGTH(string_mv_field) DESC
limit 10