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

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