WITH T1 AS

(

        SELECT  ID = 1, CNT = 0, JUSO = '서울시 성북구'  , PHONE = '010-0000-0000' UNION ALL

        SELECT  ID = 2, CNT = 0, JUSO = '서울시 강남구'  , PHONE = '010-1111-1111' UNION ALL

        SELECT  ID = 3, CNT = 0, JUSO = '서울시 강동구'  , PHONE = '010-0000-1111' UNION ALL

        SELECT  ID = 4, CNT = 0, JUSO = '인천시 남구'    , PHONE = '010-0000-1100' UNION ALL

        SELECT  ID = 5, CNT = 0, JUSO = '인천시 남구'    , PHONE = '010-9990-0000' UNION ALL

        SELECT  ID = 6, CNT = 0, JUSO = '부산시 해운대구', PHONE = '010-9992-9992' UNION ALL

        SELECT  ID = 7, CNT = 0, JUSO = '부산시 북구'    , PHONE = '010-8888-8888' UNION ALL

        SELECT  ID = 8, CNT = 0, JUSO = '제주시 서귀포구', PHONE = '010-9997-7777' UNION ALL

        SELECT  ID = 9, CNT = 0, JUSO = '제주시 서귀포구', PHONE = '010-6666-6666' UNION ALL

        SELECT  ID = 10, CNT = 0, JUSO = '경기도 용인시 수지구', PHONE = '010-6666-6666' UNION ALL

        SELECT  ID = 11, CNT = 0, JUSO = '경기도 광주시 오포읍', PHONE = '010-1111-1111' UNION ALL

        SELECT  ID = 12, CNT = 0, JUSO = '경기도 하남시 광암동', PHONE = '010-2222-2222' UNION ALL

        SELECT  ID = 13, CNT = 0, JUSO = '경기도 하남시 교산동', PHONE = '010-3333-3333'

)

SELECT  *

FROM    (

                       SELECT  TOP 5

                                      ID = MIN(ID)

                       ,              SI

                       FROM    (

                                              SELECT  *

                                              ,              SI = LTRIM(REPLACE(SUBSTRING(JUSO,0,CHARINDEX('시',JUSO)+1),SUBSTRING(JUSO,0,CHARINDEX('도',JUSO)+1),''))

                                              FROM    T1

                                              WHERE   CNT = 0

                                      ) AS A

                       GROUP BY SI

               ) AS A

INNER JOIN T1 AS B ON B.ID = A.ID

감사합니다.

적용 시켜 보겠습니다.