Posted by NiTiN on 07/27/06 04:11

> You are assuming that the rows will be returned in a particular order which
> w/o a ORDER BY statement is not guaranteed.

True, but unless there are updations and insertions occuring, the order
of the rows is usually the same as that provided by a SELECT statement
(perhaps a statistics update would cause a new execution plan to
provide rows in a different order).

When you've got duplicate entries and you don't care which ones get
deleted, you could use a modified version of the example to delete all
but one.

N.I.T.I.N.

[Back to original message]