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




No comments:

Post a Comment