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: Requires php-cofig folder to be configured or located
  • Add day, month and year with date field
  • Sorting of Alphanumeric Column
  • Err: Call to a member function get_cellmap() on a non-object by sfDomPDFPlugin in Symfony
  • Download cached flash videos of Firefox and Chrome in Linux(Ubuntu)
  • MKV to AVI using mencoder
  • Multi column check in sub query
  • Err: unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in
  • Err: WebGL not worked with Chrome 15 in Ubuntu 11.10
  • To run remote host's application from our machine

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.