让表结果union后得到自己想要的顺序，加id

select * from 
(
select 1 as id, count(1) from analytical_DataHub_C360.T_CL_PHYSICIAN union all
select 2 as id, count(1) from analytical_DataHub_C360.T_CL_PHYSICIAN_BRAND union all
select 3 as id, count(1) from analytical_DataHub_C360.T_CL_PHYSICIAN_ACTIVITY union all
select 4 as id, count(1) from analytical_DataHub_C360.T_CL_PHYSICIAN_BRAND_TYPE_LABLE union all
select 5 as id, count(1) from analytical_DataHub_C360.T_CL_PHYSICIAN_POSITION union all
select 6 as id, count(1) from analytical_DataHub_C360.T_CL_USER union all
select 7 as id, count(1) from analytical_DataHub_C360.V_CL_PHYSICIAN union all
select 8 as id, count(1) from analytical_DATAHUB_FUSION.V_CONSENT_OVERALL union all
select 9 as id, count(1) from enriched_PRESTAGE_eRSDB.V_SAS_CONSENT_INFO union all
select 10 as id, count(1) from enriched_PRESTAGE_Fusion.V_Fusion_CONSENT_INFO union all
select 11 as id, count(1) from analytical_MARTPH_PH.V_FACT_CTM_FUSION_HCP_LABLE_TO_C360_HIS union all
select 12 as id, count(1) from analytical_DataHub_C360.V_CL_PHYSICIAN_BRAND union all
select 13 as id, count(1) from analytical_DataHub_C360.V_CL_PHYSICIAN_ACTIVITY union all
select 14 as id, count(1) from analytical_DataHub_C360.V_CL_PHYSICIAN_ACTIVITY_SE union all
select 15 as id, count(1) from analytical_MARTPH_SmartEvent.V_FACT_EVENT_COST_ALL_INFO union all
select 16 as id, count(1) from analytical_DataHub_C360.V_CL_PHYSICIAN_ACTIVITY_FUSION_BCONF union all
select 17 as id, count(1) from analytical_MARTPH_PH.V_FACT_CTM_FUSION_EVENT_DTL_SRY union all
select 18 as id, count(1) from analytical_martph_PH.V_FACT_CTM_ACCESS union all
select 19 as id, count(1) from analytical_martph_PH.v_FACT_CTM_DIM_HCO_MP union all
select 20 as id, count(1) from analytical_MARTPH_PH.v_FACT_CTM_FUSION_EVENT_DTL_ALL union all
select 21 as id, count(1) from analytical_MARTPH_PH.V_FACT_CTM_FUSION_EVENT_DTL union all
select 22 as id, count(1) from analytical_MARTPH_PH.V_FACT_CTM_FUSION_EVENT_DTL_SURY_BIG union all
select 23 as id, count(1) from analytical_MARTPH_PH.v_FACT_CTM_DIM_HCP_SEG_BRAND union all
select 24 as id, count(1) from analytical_MARTPH_dbo.V_FACT_CTM_FUSION_EVENT_DTL_BIG union all
select 25 as id, count(1) from analytical_DataHub_C360.V_CL_PHYSICIAN_ACTIVITY_OPERA union all
select 26 as id, count(1) from analytical_DataHub_CustomerMerge.V_Customer_Merge_Data union all
select 27 as id, count(1) from analytical_DataHub_C360.V_CL_PHYSICIAN_BRAND_TYPE_LABLE union all
select 28 as id, count(1) from analytical_DataHub_C360.V_CL_PHYSICIAN_POSITION union all
select 29 as id, count(1) from analytical_DataHub_C360.V_CL_USER
) a order by a.id