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

Answer Posted / rajeeva tripathi

count - It returns the non null values
count(*) - It returns the null values and duplicate values

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where in ms sql server is ’100’ equal to ‘0’?

834


What is sql sandbox in sql server?

865


OPTIMIZATION OF SP,CURSOR,TRIGGERS

2420


How do I create a stored procedure in sql server?

718


What are the requirements on sql server network connections?

717


What is the difference between dataadapter and datareader?

758


How to join two tables in a single query in ms sql server?

747


how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

759


How to create a scrollable cursor with the scroll option?

704


what are constraints? : Sql server database administration

746


Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

727


What are the advantages of sql stored procedure?

800


Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

709


What are the basic features of a trigger in ms sql server?

825


Are null values the same as that of zero or a blank space?

808