select top 4 a.OFFICE_NO, a.LANG_CD, a.SEQ, a.EVENT_NM, a.EVENT_PIC1, a.EVENT_PIC2, a.SDATE, a.EDATE, a.OPEN_SDATE, a.OPEN_EDATE, a.REMARK, a.REMARK2, a.SORT_SEQ, a.USE_FLAG, a.EVENT_GUBUN,a.PRICE from T_ST_070 a where a.OFFICE_NO = 'HVN' and a.LANG_CD = 'K' and a.CLOSE_YN = 'N' and a.USE_FLAG = 'Y' and OPEN_SDATE <= CONVERT(varchar,getdate(),23) AND OPEN_EDATE >= CONVERT(varchar,getdate(),23) and a.SEQ not in (select top 0 a.SEQ from T_ST_070 a where a.OFFICE_NO = 'HVN' and a.LANG_CD = 'K' and a.CLOSE_YN = 'N' and a.USE_FLAG = 'Y' and OPEN_SDATE <= CONVERT(varchar,getdate(),23) AND OPEN_EDATE >= CONVERT(varchar,getdate(),23) order by a.sort_seq ) group by a.OFFICE_NO, a.LANG_CD, a.SEQ, a.EVENT_NM, a.EVENT_PIC1, a.EVENT_PIC2, a.SDATE, a.EDATE, a.OPEN_SDATE, a.OPEN_EDATE, a.REMARK, a.REMARK2, a.SORT_SEQ, a.USE_FLAG, a.EVENT_GUBUN,a.PRICE order by a.sort_seq

Special Offers

이벤트

Home>Special Offers>이벤트