Wednesday, 12 March 2025

Find duplicates records IN sql table

 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.

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

API run block issue run api from cmd

  ✅ Debug Checklist – “Access is Denied” (.NET / Visual Studio) 🔹 Identify Problem ☐ Error: Unable to start program (.exe) – Access is deni...

  • wrap text in excel
     if text length big make it next line shorcut is ALt+Enter or cilck on wrap text
  • generate APK using capacitor
     D:\A-MyProjects2024-2025\ReactNative2025\BookRental\android\app\build\outputs\apk\debug path of apk To build an Android app using Capacitor...
  • Dtabase design
      OLX, like many large-scale online platforms, employs a variety of data structures and technologies to manage its data effectively. While s...