org members using dense_rank

org-members-using-dense-rank.sql

WITH cte AS (
    SELECT
        org_handle,
        user_handle,
        status,
        ROW_NUMBER() OVER (PARTITION BY org_handle ORDER BY user_handle) AS rn,
        DENSE_RANK() OVER (ORDER BY org_handle) AS org_rank
    FROM
        pipes_organization_member
)
SELECT
    CASE
        WHEN rn = 1 THEN org_handle
        ELSE ''
    END AS org_handle,
    user_handle,
    status
FROM
    cte
ORDER BY
    org_rank,
    rn;
    EOQ