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

Answer Posted / harish sharma

Count(column_name) returns the number of records in the
table where the column value is not null for the particular
column.
Count(*) returns the number of all records in the table.
(including duplicates and those with nulls)

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of subquery?

787


How many replicas are maintained for each SQL Azure database?

138


How to edit table in sql server 2017?

708


Can we call future method from trigger?

727


Can I work with several databases simultaneously? : sql server management studio

783


What stored by the model?

757


Can you name a few encryption mechanisms in sql server?

742


Explain system rowset functions?

783


What is the difference between clustered and non-clustered indexes in ms sql server?

726


How can we delete a table in sql server?

763


What is sql language?

764


What is the difference between a primary key and a unique key? Are they the same?

832


Which is the latest version of sql server and when it is released?

803


What is the recursive stored procedure in sql server?

768


What is optimistic concurrency?

819