delete from table

[sumit malik]

hi friends..i hav one problem.
say i hav one table "emp_name" that contains 100 records but most of the records are duplicate for example
s
s
s
a
b
c
d
e
f
a
d
a
a
s
f
c
c
.....this way it stores hundered records.
now i want to delete all the duplicate records means i want only one entry against "a" and all other "a" should be deleted ..wats the query for this...
thanks in advance.

[Serena Chen]

by using groupby and having count.
check this out too:
http://15seconds.com/issue/011009.htm
good luck!

[b cronin]

Is this a relational table (Oracle maybe)?
If so then you can select rowid and delete the min or max row id having a count > 1.