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

What xml support does the sql server extend?

751


Tell me about pre-defined functions of sql?

886


What is the difference between rank and dense_rank?

710


What happens on checkpoint?

807


wat wil hapn if we give the both read and deny read permission to user?

1885


What are the disadvantages of using querystrings to send data from one page to another?

787


Tell me what is difference between view and materialized view?

732


what is blocking? : Sql server database administration

767


What are constraints in microsoft sql server?

764


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

818


How do I find the default sql server instance?

732


Are semicolons required at the end of sql statements in sql server 2005?

763


How to get a list of columns in a view using the "sp_help" stored procedure?

828


How to provide default values to function parameters?

794


What is pessimistic concurrency?

733