I have the following table:
create table foo(
My first attempt at my query is the following:
select distinct description,threat_id from foo where threat_id=1234567;
...and I got the error:
Inconsistent datatypes: expected - got CLOB
Since I know I can't select distinct on a clob datatype, How can I select from this
table such that I do not get duplicate descriptions?