How to check for duplicates in SQL
In this case we have 3 keys for this table:
LineNumber
JournalID
InventTransRecVersion
Here is the query used in order to find the duplicates:
SELECT DATAAREAID, JOURNALID, LINENUMBER, INVENTTRANSRECVERSION, COUNT(RECID)
FROM CNBINVENTTRANSFERORDERL...
jobourgoin.hashnode.dev1 min read