regexp_like
From: <carlos.ohiggins_at_yahoo.com>
Date: Mon, 3 Nov 2008 06:40:56 -0800 (PST)
Message-ID: <b84d02ed-25c5-4574-9c28-344b1fe10055@x16g2000prn.googlegroups.com>
Date: Mon, 3 Nov 2008 06:40:56 -0800 (PST)
Message-ID: <b84d02ed-25c5-4574-9c28-344b1fe10055@x16g2000prn.googlegroups.com>
Hi,
I want to run a distinct query against a text field."something,
something else, etc, etc,"
I have got this far:
SELECT distinct (Summary), count( distinct (Summary)) FROM report
where
Cost> 1000 group by Summary;
But this is looking at whole text field, and I just want to use the first portion of the comma separated text field. I expect regexp_like is the solution but I cannot quite figure it out!
I think just a few hints would help me crack this one!
TIA Carlos Received on Mon Nov 03 2008 - 08:40:56 CST