Home » SQL & PL/SQL » SQL & PL/SQL » Oracle SQL a=b and b=a (Oracle 12C)
Oracle SQL a=b and b=a [message #685151] Fri, 29 October 2021 06:24 Go to next message
rahul1982
Messages: 53
Registered: November 2011
Location: Pune
Member
Hello team,

Below are my table values, there are 2 columns. Below example has ColA value present in ColB as well as ColB in ColA hence want to delete one of the record.

ColA			ColB	
00300000003TuDlAAK	003000000068VWTAA2
003000000068VWTAA2	00300000003TuDlAAK
Any clues or help would be appreciated.

Thanks!

[Updated on: Fri, 29 October 2021 06:32]

Report message to a moderator

Re: Oracle SQL a=b and b=a [message #685152 is a reply to message #685151] Fri, 29 October 2021 08:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Same thing as in the following topic: SQL Query for duplicates.

Re: Oracle SQL a=b and b=a [message #685153 is a reply to message #685151] Fri, 29 October 2021 09:10 Go to previous messageGo to next message
rahul1982
Messages: 53
Registered: November 2011
Location: Pune
Member
Thanks, its working as expected.
Re: Oracle SQL a=b and b=a [message #685155 is a reply to message #685153] Fri, 29 October 2021 14:25 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
rahul1982 wrote on Fri, 29 October 2021 09:10
Thanks, its working as expected.
But if the example you gave constitutes a 'duplicate record' - the business meaning of ColA is the same as the business meaning of ColB, then I'd have some serious questions about the data design.
Previous Topic: Long query with WITH not responding
Next Topic: Data Dictionary for Collection Bind variables
Goto Forum:
  


Current Time: Thu Mar 28 04:39:16 CDT 2024