On Oct 5, 8:12 am, shenan...@gmail.com wrote:
> INSERT INTO deletetable
> select * from old table
> (
> DELETE FROM existingtable
> )
> ;

Not as such, but there is a way around it. Have a look at the slide
titled "Moving duplicate rows" in the "SQL on Fire - Part 2"
presentation available at the following link:

http://www.iiug.org/waiug/present/Fo...Forum2006.html

--Jeff