Returns Ultimateparent Details With Levels Recursively For A Given Company

This query returns a recursive corporate ownership hierarchy for a given company, starting from the selected company and recursively climbs upward through parent ownership relationships based on specific relationship types. Tags - Backward Recursion, UltimateParentID, Corporate tree, Corporate Hierarchy, Company Hierarchy,Levels, RelationshipType Between Child UltimateParent

Enhancement Date: 11/24/2025

  • SourceMarket Intelligence
  • Data Packages Required
    Base CompanyCompany Relationships Point In TimeCompany Relationships Point In Time Reference
  • Associated Datasets
    カンパニーリレーションシップ

Query Types

  • MSSQL
  • Snowflake