The set rowcount command can be used to limit the number of rows impacted by
any basic query. Use like below

set rowcount 1
delete table where condition


----- Original Message -----
From: "Fang, Elaine" <Elaine.[Email Address Removed] <[Email Address Removed] Monday, August 12, 2002 2:59 PM
Subject: 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









---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page