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

How to write an inner join with the where clause in ms sql server?

792


What is scrollable cursor?

783


ow to bring suspect mode datbase online from scratch

1603


What is in place upgrade in sql server?

755


Explain the difference between functions and stored procedures in sql server?

731


how we use window authentication connection with sql server.?

846


What is difference between join and natural join?

675


Does full backup break log chain?

751


How to stop a loop early with break statements in ms sql server?

789


Can I run multiple instances of sql server 2000 at the same time on one computer?

839


How to delete a database in ms sql server?

751


Can you create a logon trigger in sql server 2005 express edition?

838


What is the difference between web edition and business edition?

105


Define left outer join in sql server joins?

738


Do you know what is a linked server in sql server?

735