Advanced Search

Registros duplicados SQL Server

/ Published in: SQL
Save to your folder(s)
Saber el numero de registro duplicados en una tabla

Expand | Embed | Plain Text

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.