id_, main_id_, fill_date_, subject_code_, subject_name_, subject_name_en_, subject_level_, subject_unit_, enterprise_code_, enterprise_name_, enterprise_name_en_, budget_, budget_ytd_, last_time_ SELECT q.enterprise_code_ FROM ( SELECT enterprise_code_, column_ FROM qf_finance_bs_budget_d WHERE main_id_ = #{mainId} GROUP BY enterprise_code_, column_ ORDER BY column_ ) q SELECT q.subject_code_ FROM (SELECT subject_code_, sn_ FROM qf_finance_bs_budget_d WHERE main_id_ =#{mainId} GROUP BY subject_code_, sn_ ORDER BY sn_) q