SVC_CATEGORIES_CHILD_CNT_V

Details

• Schema: FUSION

• Object owner: SVC

• Object type: VIEW

Columns

Name
PARENT_CATEGORY_ID CHILD_COUNT

Query

SQL_Statement
Select * from (SELECT category_id as parent_category_id ,(Select count(*) from svc_categories_b where parent_category_id=x.category_id) as CHILD_COUNT FROM svc_categories_b x) where CHILD_COUNT>0