I want to run the count(*) query to get result just 1 single row. getting unique distinct docindex_i count from the table, table has 431k row count in total, but there are multiple rows with same docindex_i , just want to see a unique total row count with distinct docindex_i.
how to use the below conditions. getting error.
select COUNT(*) from (select distinct docindex_i from [docudeck]);
Thanks a lot for the helpful info