count distinct records (all columns) not working

Viewed 49262

what's proper syntax for

count (distinct *) from t1

I am getting he following error:

[Err] 42000 - [SQL Server]Incorrect syntax near the keyword 'distinct'.

1 Answers
Related