Click here to Skip to main content
15,891,253 members
Articles / Programming Languages / SQL

COUNT of DISTINCT Rows in SQL Server

Rate me:
Please Sign up or sign in to vote.
4.13/5 (7 votes)
26 Nov 2010CPOL 79.5K   6  
COUNT of DISTINCT Rows in SQL Server

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

Please Sign up or sign in to vote.
26 Nov 2010Vivek Johari
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

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
India India
Ravikiran Malladi is a senior software professional in Microsoft technologies. He has global IT experience of over 10 years and has compulsive habit of writing tools, particularly for the projects he works on. He has vast experience in the roles of senior developer, technical analyst, technical architect besides in technical lead roles.

His hobbies include chess, music, cricket, web sites along side writing technical articles and technical blogs.

Comments and Discussions