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

Answer Posted / sachin rathi

Count(column name or exp) returns the no. of records for a
specific/particular column of table excluding null values
whereas Count(*) returns all the rows/records in the table
including duplicated and null values

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create percentile function?

124


What is the correct order of the logical query processing phases?

733


What is the difference between createstatement and preparedstatement?

733


What is the use of for clause?

828


What are the differences between DDL, DML and DCL in SQL?

999


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

800


What happens to a trigger with multiple affected rows?

735


According to you what goes into making the best database administrator? : sql server database administration

777


What samples and sample databases are provided by microsoft?

810


What is a raid and what are different types of raid configurations?

910


What is a collation?

868


Explain few examples of RDBMS?

816


Why we use functions in sql server?

797


List the types of recovery model available in sql server?

730


What are policy management terms?

785