Home » SQL & PL/SQL » SQL & PL/SQL » How To Remove Duplicates (Oracle 10G)
How To Remove Duplicates [message #404853] Mon, 25 May 2009 00:38 Go to next message
Messages: 53
Registered: January 2008
How to write Sql Query to remove duplicates in the below situation.

SELECT '1,5,10,15,10,20,5' FROM DUAL

After removal of duplicates it should be

Re: How To Remove Duplicates [message #404855 is a reply to message #404853] Mon, 25 May 2009 01:04 Go to previous message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Convert to rows, use distinct, convert back to string.

The question has already been asked and each steps also and many times.

Previous Topic: Data Type Issue
Next Topic: Copy data from one database to other
Goto Forum:

Current Time: Sun Jul 23 06:05:52 CDT 2017

Total time taken to generate the page: 0.10596 seconds