pralash
18th November 2017, 08:43
Hello,

I'm using the following sql query for find out the distinct count for a column... But I got the result as wrong( total number of records) instead of find out the distinct count..

select distinct count(tctls903.user):counter
from tctls903
selectdo
rprt_send()
endselect

Could you please assist me how to get the count of distinct column value by modifying the above query...
Thanks in advance...
Pralash