Delete repeated records in a sql server table

Navigation
0

I want to delete repeated records from my database and leave only 1, any ideas?

    
asked by Andrex_11 12.01.2018 в 22:38
source

1 answer

0

With this instruction you can delete repeated records: 

delete tbl from
(select row_number() over(partition by nro_identificacion) as 'ID'
from <tabla>) tbl
where ID<>1

You tell us!

regards,

    
answered by 12.01.2018 в 22:56
He stores everything but only shows me the last Problems executing mysql -u -p command