This email was created by [your name] who thought you would be interested in the following Article:
"COUNT of DISTINCT Rows in SQL Server"
Nice tip :)But if you have any column say empid which have the unique constraint then it is better to use the following SQL queryselect count(distinct empid ) from employees
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!