USE COMMON
-------------------TO VIEW DUPLICATE RECORD BY ACCOUNT CODE
SELECT COUNT(T1.F1) AS G1, T1.F2 AS G2 FROM (SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM COMMON.DBO.ACCOUNT_MASTER
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23M001.DBO.ACCOUNT_MASTER UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23M002.DBO.ACCOUNT_MASTER
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23S001.DBO.ACCOUNT_MASTER UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23S003.DBO.ACCOUNT_MASTER 
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23V001.DBO.ACCOUNT_MASTER) AS T1 GROUP BY T1.F2 HAVING COUNT(T1.F1) >1

-------------------TO VIEW DUPLICATE RECORD BY ACCOUNT CODE
SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM COMMON.DBO.ACCOUNT_MASTER WHERE AccName='MANSI EXCLUSIVE'
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23M001.DBO.ACCOUNT_MASTER WHERE AccName='MANSI EXCLUSIVE'
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23M002.DBO.ACCOUNT_MASTER WHERE AccName='MANSI EXCLUSIVE'
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23S001.DBO.ACCOUNT_MASTER WHERE AccName='MANSI EXCLUSIVE'
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23S003.DBO.ACCOUNT_MASTER WHERE AccName='MANSI EXCLUSIVE'
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23V001.DBO.ACCOUNT_MASTER WHERE AccName='MANSI EXCLUSIVE'

-------------------TO VIEW DUPLICATE RECORD BY ACCOUNT CODE
SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM COMMON.DBO.ACCOUNT_MASTER WHERE AccCode='23LM070'
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23M001.DBO.ACCOUNT_MASTER WHERE AccCode='23LM070'
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23M002.DBO.ACCOUNT_MASTER WHERE AccCode='23LM070'
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23S001.DBO.ACCOUNT_MASTER WHERE AccCode='23LM070'
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23S003.DBO.ACCOUNT_MASTER WHERE AccCode='23LM070'
UNION SELECT AccCode COLLATE DATABASE_DEFAULT AS F1, AccName COLLATE DATABASE_DEFAULT AS F2 FROM T23V001.DBO.ACCOUNT_MASTER WHERE AccCode='23LM070'

SELECT * FROM USER_WORK_DETAIL WHERE COMPANY LIKE '%SAKSHAM CREATION%'