HOME > 자료실 > 지난자료 검색
참가업체별 검색(2024)
등록된 참가업체 : 총 203개사
select top 30 * from TB_COMPANY_EXH where 1=1 and isnull(del,'') <> 'Y' and isnull(del,'') <> 'Y' and syear = '2024' and state = 'Y' ORDER BY case when company_name_kor like '' then 2 else 1 end, replace(replace(replace(company_name_kor,'(사)',''),'(재)',''),'(주)','') asc