Find the SQL Distinct count
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
Could you please assist me how to get the count of distinct column value by modifying the above query...
Thanks in advance...