SQL duplicate records
select EMPID ,Forminfoid,FormName ,count(*) as dcount
from tbl_FilesMigrationLogs
group by EMPID,Forminfoid,FormName
HAving COUNT(*) >1
track by multiple columns.
very usefull link to verify ai content https://www.youtube.com/watch?v=pULGt0Rme58 Click
No comments:
Post a Comment