how to delete a duplicate row?

how to delete a duplicate row?

 

  

Hi list,

For a table w/o PK and unique index, how to delete a duplicate row? Is there any system defined column (e.g. rowid etc) that I can use?

Thanks!
Elaine








MS Sql Server LazyDBA home page