Tip for using the COUNT() function
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
Tip for using the COUNT() function
Rating:
When the COUNT(*) function is used, it includes NULL values, whereas if the COUNT(expression) function is used, it ignores NULL values. In order to avoid the counting of NULL values, a user should use the COUNT(expression) function.
Rating:
Was this information helpful?
Other articles
- What are the methods of index defragmentation?
- What is SSAS?
- What is Database Engine Tuning Advisor?
- What is a page split?
- What is a temporary table?