자문자답이네요


select SVUSERID
, Row_Number() over(order by CAST(SVDT AS float)) as RN
, STFSEQ
, PBLSH
, (select CODNAME from FN_COD_MST where GRID='1011' and COD=PBLSH) PBLSHCODE
, STFNAME
, ZIPCODE
, ADRESS1 + ' ' + ADRESS2 as ADRESS
, ADRESS2
, TELNO1 + '-' + TELNO2 + '-' + TELNO3 as TELNO
, PNAME
, EMAIL
, JSSEQ
, SVDT
from FN_STF_MST
where PBLSH in (select COD from FN_COD_MST where GRID='1011' and CODNAME like '%' + '골드' + '%')
AND SVUSERID not in (
select SVUSERID
from FN_STF_MST
where PBLSH in (select COD from FN_COD_MST where GRID='1011' and CODNAME like '%' + '골드' + '%')
GROUP BY SVUSERID
having count(SVUSERID) > 1
)
OR STFSEQ in(
select top 1 STFSEQ
from FN_STF_MST
where SVUSERID =
( select SVUSERID
from FN_STF_MST
where PBLSH in (select COD from FN_COD_MST where GRID='1011' and CODNAME like '%' + '골드' + '%')
GROUP BY SVUSERID
having count(SVUSERID) > 1
) order by SVDT
)

다른 의견 있으신분 부탁드립니다.