Registros duplicados SQL Server


/ Published in: SQL
Save to your folder(s)

Saber el numero de registro duplicados en una tabla


Copy this code and paste it in your HTML
  1. SELECT * , COUNT( * ) AS num
  2. FROM INTImportaExcel
  3. GROUP BY
  4. CV_INVENTARIO,
  5. DES_ACTIVO,
  6. MARCA,
  7. MODELO,
  8. SERIE,
  9. CS_JURISDICCIONES,
  10. CS_CUUM
  11. ORDER BY num DESC

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.