distinct on CLOB column ?

[desiboys]

select distinct CLOBtextcolumn from table  query work kavatledu

alternative options enti ?

[argadorn]

clob in varchar 3000 enthako cast chesi distinct paina evvu vasthundhi emo ...

[Mr Mirchi]

pyna suggestion work avvakapothe......  group by function raayi aa column meedha..then you will get distinct results...export chesuko or iko table create chesuko vachina distinct results tho

 

select clobCloumn, count(clobCloumn) from table group by clobColumn

 

 

null values vunte null check pettuko

[Naaperushiva]

26 minutes ago, Mr Mirchi said:

pyna suggestion work avvakapothe......  group by function raayi aa column meedha..then you will get distinct results...export chesuko or iko table create chesuko vachina distinct results tho

 

select clobCloumn, count(clobCloumn) from table group by clobColumn

 

 

null values vunte null check pettuko

exactly