desiboys Posted March 23, 2017 Report Share Posted March 23, 2017 select distinct CLOBtextcolumn from table query work kavatledu alternative options enti ? Quote Link to comment Share on other sites More sharing options...
argadorn Posted March 23, 2017 Report Share Posted March 23, 2017 clob in varchar 3000 enthako cast chesi distinct paina evvu vasthundhi emo ... Quote Link to comment Share on other sites More sharing options...
Mr Mirchi Posted March 23, 2017 Report Share Posted March 23, 2017 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 Quote Link to comment Share on other sites More sharing options...
Naaperushiva Posted March 23, 2017 Report Share Posted March 23, 2017 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.