USE T202122 


SELECT RTNSRNO FROM TmpGRDataDuplicate GROUP BY RTNSRNO HAVING COUNT(RTNSRNO)>1 
SELECT * FROM RETURN_GOODS_DETAIL WHERE RTNSRNO LIKE '%000074%'