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(expr) -> returns the number of records in the table
where the expr is not null in the particular column.
Count(*) -> returns the number of all records in the table.
(including duplicates and those with nulls)

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain something about security and SQL Azure?

134


What purpose does the model database server?

1101


What is the use of tempdb? What values does it hold?

1072


What is key attribute?

935


What is bulkcopy in sql?

944


Why use cursor in sql server?

1081


What happens if we shrink log file in sql server?

983


What are the instances when triggers are appropriate?

979


What are the disadvantages of merge replication?

1424


Explain Capacity planning to create a database? and how to monitor it?

4204


What is the difference between migration and upgradation in sql server?

1097


What is an entity-relationship diagram (erd)?

1214


Tell me what is de-normalization and what are some of the examples of it?

1050


What does asynchronous call backs means?

1158


What is the minimum recommended amount of ram for sql server 2012 enterprise?

935