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

Answer Posted / manisha

count fetches non-null value from out of a query but count
(*) includes null values also.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I schedule a sql server profiler trace?

731


How to provide column names in insert statements in ms sql server?

861


How sql server executes a statement with nested subqueries?

751


Does a specific recovery model need to be used for a replicated database? : sql server replication

755


What is key set driven?

744


What is use of dbcc commands?

838


How does Report Builder support Analysis Services cubes?

136


Tell me what is use of except clause? How it differs from not in clause?

744


How to start sql server browser service?

839


What is left outer join in sql server joins?

735


What is the difference between for trigger and after trigger?

789


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

824


How to create a trigger for insert only?

810


New concepts of sql server 2005 use in your project.

2129


what is a live lock? : Sql server database administration

688