hi,
hab diese query um eine auswertung des COUNTRY_CODE "DEU" zu bekommen.
ich möchte für jedes COUNTRY_CODE diese auswertung haben , ohne expleziet das COUNTRY_CODE im code zu definieren..
irgend eine idee?
hab diese query um eine auswertung des COUNTRY_CODE "DEU" zu bekommen.
ich möchte für jedes COUNTRY_CODE diese auswertung haben , ohne expleziet das COUNTRY_CODE im code zu definieren..
irgend eine idee?
Code:
Select COUNT(ORDER1_ID) AS ORDER1,
COUNT(ORDER2_ID) AS ORDER2,
COUNT(ORDER8_ID) AS ORDER8
from RDF_ADMIN_HIERARCHY ahr
left join RDF_FEATURE_NAMES fns1 on ahr.ORDER1_ID = fns1.FEATURE_ID and 'N' = fns1.IS_EXONYM and 'B' = fns1.NAME_TYPE and 'A' = fns1.OWNER
left join RDF_FEATURE_NAME fne1 on fns1.NAME_ID = fne1.NAME_ID
left join RDF_FEATURE_NAME_TRANS fnt1 on fns1.NAME_ID = fnt1.NAME_ID
left join RDF_FEATURE_NAMES fns2 on ahr.ORDER2_ID = fns2.FEATURE_ID and 'N' = fns2.IS_EXONYM and 'B' = fns2.NAME_TYPE and 'A' = fns2.OWNER
left join RDF_FEATURE_NAME fne2 on fns2.NAME_ID = fne2.NAME_ID
left join RDF_FEATURE_NAME_TRANS fnt2 on fns2.NAME_ID = fnt2.NAME_ID
left join RDF_FEATURE_NAMES fns3 on ahr.ORDER8_ID = fns3.FEATURE_ID and 'N' = fns3.IS_EXONYM and 'B' = fns3.NAME_TYPE and 'A' = fns3.OWNER
left join RDF_FEATURE_NAME fne3 on fns3.NAME_ID = fne3.NAME_ID
left join RDF_FEATURE_NAME_TRANS fnt3 on fns3.NAME_ID = fnt3.NAME_ID
left join RDF_FEATURE_NAMES fns4 on ahr.BUILTUP_ID = fns4.FEATURE_ID and 'N' = fns4.IS_EXONYM and 'B' = fns4.NAME_TYPE and 'A' = fns4.OWNER
left join RDF_FEATURE_NAME fne4 on fns4.NAME_ID = fne4.NAME_ID
left join RDF_FEATURE_NAME_TRANS fnt4 on fns4.NAME_ID = fnt4.NAME_ID
where ahr.ISO_COUNTRY_CODE = 'DEU'