ac senthilkumar's blog

________________________________________________________________________________________

Thursday, March 10, 2011

Get Distinct values from comma separated values

select
            distinct(x)
from (
            select

                      regexp_split_to_table('3101RE402,3101RE403,3101RE403',',') as x
         ) as y




Posted by Senthil kumar at 3/10/2011 01:12:00 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: PostgreSQL

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Popular Posts

  • Err: Call to a member function get_cellmap() on a non-object by sfDomPDFPlugin in Symfony
  • Err: No entry for terminal type "unknown"; using dumb terminal settings.
  • Bulk Convert Office Documents into PDF using unoconv
  • PDOException: Invalid text representation
  • quicktime demuxer not found in Ubuntu 11.10
  • Err: Unlock Login Keyring in Ubuntu 11.10 problem
  • Internal field separator (IFS) for shell scripts
  • Disable the password window asked everytime in PgAdmin
  • Postgresql 9.x to 8.x restore issue with bytea field contains hex values
  • Err: apt-get update not working

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Search in this Blog ...

Labels

  • Linux (49)
  • Errors (44)
  • PostgreSQL (44)
  • Ubuntu (38)
  • PHP (34)
  • How to (33)
  • Java Script (15)
  • Tips (15)
  • Apache (11)
  • Regular Exp (11)
  • Drupal (9)
  • Open Office (9)
  • CSS (6)
  • Flash Builder for PHP (6)
  • Symfony (5)
  • Web (5)
  • Windows (5)
  • Eclipse (3)
  • Programming (3)
  • Advanced SQL (2)
  • Firefox (2)
  • Android (1)
  • Chrome (1)
  • HipHop (1)
  • Java (1)
  • Links (1)
  • MySQL (1)
  • Softwares (1)
  • Utilities (1)

Followers

Senplusone. Simple theme. Powered by Blogger.