The Difference between 'Count' and 'Count(*)'

Answer Posted / vijay dev saxena

Count(exp): Counts the number of rows excluding null values.
Count(*) : Counts the number of rows including null and
duplicates records.

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create new tables with "select ... Into" statements in ms sql server?

735


what are defaults? : Sql server database administration

757


What are different types of constraints?

740


what's new in sql server 2016?

766


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

790


What is a partition key?

712


Will sql server 2005 allow you to reduce the size of a column?

742


What is the full meaning of dml?

763


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

796


Explain how you can configure a running aggregate in SSRS?

133


When multiple after triggers are attached to sql table, how to control the order of execution?

825


What is the use of commit?

795


Explain how you can deploy an SSRS report?

124


What are the different types of join?

852


Is null vs coalesce?

682