MySQL 첫번째 또는 마지막 행 출력 예제

오라클의 Rownum = 1개념

limit 1 Order By A

SELECT

R.RESULT_SEQ

 , R.EMP_NO

 , R.DEPT_NO

 , R.PJT_CD

 , R.PJT_TYPE

 , P.PJT_NM

 , R.PJT_PART

     , (SELECT DATE_FORMAT(START_DT, '%Y-%m-%d')  

FROM

RH_RESULT

WHERE

EMP_NO = 2015103

AND PJT_CD = R.PJT_CD

AND USE_YN = 'Y'

AND PJT_TYPE <> '휴일/휴가' 

     ORDER BY START_DT

                limit 1) AS START_DT

              , (SELECT DATE_FORMAT(END_DT, '%Y-%m-%d')  

FROM

RH_RESULT

WHERE

EMP_NO = 2015103

AND PJT_CD = R.PJT_CD

AND USE_YN = 'Y'

AND PJT_TYPE <> '휴일/휴가' 

     ORDER BY START_DT DESC

                limit 1

              ) AS END_DT  

 , R.RATE_CD

 , R.CREATE_USER

 , R.CREATE_DATE

 , R.CREATE_IP

 , R.UPDATE_USER

 , R.UPDATE_DATE

 , R.UPDATE_IP  

 , R.MEMO_INFO

 , R.USE_YN

FROM

RH_RESULT R,

RH_PROJECT P

WHERE

R.EMP_NO = 2015103

AND R.PJT_CD = P.PJT_CD

AND R.USE_YN = 'Y'

AND P.USE_YN = 'Y'

AND R.PJT_TYPE <> '휴일/휴가' 

Group BY R.PJT_CD

ORDER BY R.START_DT