select memid, ownerid, fsl_tableCode, LinkID, LinkType, MemoType , cast(LinkID as varchar(20)) + LinkType + MemoType AS groupID from tbl_PRD_Memo m1 where 1 < ( select count (*) from tbl_PRD_Memo m2 where m1.ownerid = m2.ownerid and m1.fsl_tableCode = m2.fsl_tableCode and m1.linkid = m2.linkid and m1.linkType = m2.linkType and m1.memoType = m2.memoType ) Order by ownerid, fsl_tableCode, LinkID, LinkType, MemoType, memid desc delete from tbl_PRD_Memo where memid = #qry_getMemoData.memid#;

memo id	linkid	linkType	memoType	GroupID	ACTION
#qry_getMemoData.memid#	#qry_getMemoData.LinkID#	#qry_getMemoData.LinkType#	#qry_getMemoData.MemoType#	#qry_getMemoData.groupid#	SAVE
#qry_getMemoData.memid#	#qry_getMemoData.LinkID#	#qry_getMemoData.LinkType#	#qry_getMemoData.MemoType#	#qry_getMemoData.groupid#	DELETE