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
someswar1
Messages: 53
Registered: January 2008
Member
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
1,5,10,15,20

Regards
Someswar
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: 64103
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.

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


Current Time: Sat Dec 03 20:12:14 CST 2016

Total time taken to generate the page: 0.09192 seconds