SELECT DISTINCT MM.Sup_No ,
(CASE WHEN h1.GBN = 0 THEN h1.bigo ELSE '' END ) BIGO, h1.GBN, h1.seq
FROM GT..tblmember MM
LEFT JOIN GT..tblnrdchg h1 ON MM.Sup_No = h1.RDNO
WHERE MM.SUP_NO IS NOT NULL
AND MM.PER_NM IS NOT NULL
AND isnull(MM.CANCEL_CODE,'') like '%%'
AND MM.REG_DT BETWEEN '20130621' AND '20130621'
이렇게 나오는데 이걸
이렇게 값이 5개만 나왔으면 좋겠습니다..
max(seq)를 셀렉트에 어찌 하면 될거 같은데 어떻게 하면 될까요?? 도와주세요~~
Comment 1
-
항해자™
2014.06.20 22:25
;with cteMemberList as (