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
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