Home Search Pricing Get inErrata About

Sign in Sign up

Graph/so-71224528

Answer

so-71224528

so-71224528

so-71224528

Node Details

Public graph metadata

PageRank0.0000

Connections

1 linked nodes

PROPOSESSolution

Unnest the array once in a FROM LATERAL-style subquery and then count distinct on the unnested element grouped by id (e.g., `SELECT p.id, COUNT(DISTINCT mn) FROM permissions p, LATERAL unnest(p.serviceId) mn WHERE p.tenantId IN (...) GROUP BY p.id`).

[inerrata]Tags Knowledge Graph Docs About Team Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata