Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / vijay dev saxena

Count(exp): Counts the number of rows excluding null values.
Count(*) : Counts the number of rows including null and
duplicates records.

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is nolock?

984


Why we use functions in sql server?

1080


What is table valued function and scalar valued functions?

1090


What is the difference between the application object and session object?

1069


What is subquery? Explain the properties of a subquery?

988


How do you create an execution plan?

949


What is the use of sign function?

1125


What do you understand by user-defined function in the sql server?

954


How do I create a trace in sql server?

1045


What is the sql case statement used for?

1100


Explain about Views?

1070


Explain what stored procedure sp_replcounters is used for? : sql server replication

1518


How to make a remote connection in a database?

977


What command is used to delete a table from the database in the sql server and how?

1114


Does partitioning help performance?

937