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

Answer Posted / t.lakshmi

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

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the instances when triggers are appropriate?

533


What is the stuff?

535


your distribution database is full what will u do

1687


How to rebuild indexes with alter index ... Rebuild?

600


How many categories of data types used by sql server?

602






What is filestream?

566


Which rendering formats are affected by the pagesize properties?

106


What are the types of database recovery models?

605


What are the features of Embedded SQL

689


What is acid db?

521


Explain how many types of relationship?

585


Write the syntax for stuff function in an sql server?

543


Do you know what are the reporting services components?

539


How do I find query history in sql server?

524


Tell me in brief how sql server enhances scalability of the database system?

542