SELECT COUNT(PRTN_UID) FROM ( select DISTINCT PRTN_UID FROM PRE_PRODUCT_INFO WITH(NOLOCK) where ctrt_date_end >= '20190915' and ctrt_date <= '20190915' and use_flag ='O' and BDONG_CD like'11680%' and rlsttype_cd ='A01' ) AA

select PRTN_UID from ( select distinct PRTN_UID FROM PRE_PRODUCT_INFO WITH(NOLOCK) where ctrt_date_end >= '20190915' and ctrt_date <= '20190915' and BDONG_CD like'11680%' and rlsttype_cd ='A01' and use_flag ='O' ) aa ORDER BY NEWID()