SELECT
EmployeeNumber,
COUNT(*) as CountOfDuplicates
FROM
profiles
GROUP BY
EmployeeNumber
HAVING
COUNT(*) > 1;
Subscribe to:
Post Comments (Atom)
7 Common mistakes in Dot Net — You can avoid
There are many common mistakes made during .NET (ASP.NET, .NET Core) development, which affect performance, security, and code… Code Crack...
-
Points 1.complex page layouts and adherence to code standards. 2.primeNG pagination 3.ngcontent 4.ngdestory(memorylekage) 5.datatransfer wi...
-
Check duplicate count based on 3 columns combo select EMPID,FORMinfoID,FormName,Count(*) as counts from tbl_FilesMigrationLogs group by Em...
No comments:
Post a Comment