SELECT COUNT(PRTN_UID) FROM ( select DISTINCT PRTN_UID FROM PRE_PRODUCT_INFO WITH(NOLOCK) where ctrt_date_end >= '20210613' and ctrt_date <= '20210613' and use_flag ='O' and BLDCODE ='L30054' and rlsttype_cd ='A01' ) AA

select PRTN_UID from ( select distinct PRTN_UID FROM PRE_PRODUCT_INFO WITH(NOLOCK) where ctrt_date_end >= '20210613' and ctrt_date <= '20210613' and BLDCODE ='L30054' and rlsttype_cd ='A01' and use_flag ='O' ) aa ORDER BY NEWID()