how to delete single row from a two have same value

[sanjeevpillai]

sir,
take an example in an table there are 10 rows and 2 rows are identical they contain same values. i want to delete only one row from these two row. it is possible?
if it is possible how can i delete?

[buser]

it's possible if you've got some unique id in your table
Something like that:
delete from [table]
where [table].id = (select min(id) from [table] t where t.someval = [table].someval)
and t.someval = 'eqval'

[buser]

MS solution (http://support.microsoft.com/default.aspx?scid=kb;en-us;139444)