Home » SQL & PL/SQL » SQL & PL/SQL » To delete a table from another table which has duplicate values in it (Windows ,9i)
To delete a table from another table which has duplicate values in it [message #333906] Mon, 14 July 2008 17:55 Go to next message
maggy_ashee
Messages: 70
Registered: May 2007
Member
Hi All,

I have requirement wherein I have a table AAA which has duplicate rows in it and I need to subtract table BBB from it.

Table AAA minus Table BBB also removes the duplicate records present in it.

Also i tried to make a distinct of table AAA and tried to minus BBB and even that was unsuccessfull.Please let me know if you can help me with any other alternatives.

Thanks in Advance!! Appreciate your help.

[Mod-Edit: Frank removed colouring and ridiculous font-size]

[Updated on: Tue, 15 July 2008 00:20] by Moderator

Report message to a moderator

Re: To delete a table from another table which has duplicate values in it [message #333907 is a reply to message #333906] Mon, 14 July 2008 17:57 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Too bad both the SEARCH function on this forum & GOOGLE are broken for you.
Please wait patiently while repairs are completed.
A more complete response will follow Real Soon Now.
Re: To delete a table from another table which has duplicate values in it [message #334001 is a reply to message #333906] Tue, 15 July 2008 03:01 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Look into NOT IN or NOT EXISTS subqueries
Previous Topic: BULK UPDATE
Next Topic: Row to column conversion
Goto Forum:
  


Current Time: Sat Dec 03 01:12:33 CST 2016

Total time taken to generate the page: 0.11391 seconds