advanced sql do count(distinct on more than one column
Question

In advanced sql I can do select count(distinct {mytable}.[value]) however from looking online I should be able to do count based on a distinct of more than one column - so something like select count(distinct {mytable}.[value1], {mytable}.[value2], {mytable}.[value3]) but it keeps coming up with an error saying error near the ",".  So not sure if I am doing something wrong or if its a limitation with the sql server.  Anyone run into this or get it working?

Hi Jason,

Advance query with count multiple distinct column is not working however its working for one distinct column.

Can you try query some with group by some thing like below

SELECT count(*) from {Test}
group by 
{Test}.[Test1],{Test}.[Test2] 
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.