Hi,

Count is an aggreate function which accepts only one input parameter. In your query you are trying to input two columns as input to the function. So the below query is giving you error.

select count(distinct co_number, contact)

from Test_contact

Refer

http://msdn.microsoft.com/en-us/library/ms175997.aspx