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

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

941


What is bulkcopy in sql?

895


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1964


How do you test your database? : sql server database administration

947


What is the New in SQL server 2008?

916


How the authentication mode can be changed?

1073


Can we delete data from a view?

880


Explain syntax for viewing, dropping and disabling triggers?

896


What language is sql server written in?

980


How to add more data to the testing table in ms sql server?

995


John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

881


What is use of attributehierarchyenabled? : sql server analysis services, ssas

1158


What is snapshot replication?

997


Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

902


What is primary key and example?

893