Tuesday, 3 September 2013

Group by with CLOB in select-statement

Group by with CLOB in select-statement

My select-statement looks like:
Select column1, column2
From Table1
Group By column2
column1 is a CLOB and I want to recieve one of the values that is part of
one group, I know they are all the same so it doesnt matter which one I
get. I've tried functions like MIN and MAX but they doesn't accept CLOB as
type.
To be clear I dont want to aggregate the CLOBs just pick one of them.
This is a simplification of the actually select-statement and the GROUP
BY-clause is neccesary.
so with this data
column1 column2
qwerty 1
qwerty 1
asdfgh 2
asdfgh 2
I want to get
qwerty 1
asdfgh 2
Any ide how this could be done?

No comments:

Post a Comment