|
|
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.
Navigation:
[Reply to this message]
|