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 / harish sharma

Count(column_name) returns the number of records in the
table where the column value is not null for the particular
column.
Count(*) returns the number of all records in the table.
(including duplicates and those with nulls)

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where can you find the error log information? : sql server database administration

1070


What are information schema views?

1027


What are the types of subscriptions in SQL Server replication?

1102


What is transaction server consistency?

1104


What is the server name for sql management studio?

1096


How can I create a new template for import ? : sql server management studio

1113


What are the approximate numeric data types?

986


How to create a testing table with test data in ms sql server?

1140


Do you know what is lock escalation?

1055


What is the most common type of join?

1038


what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1050


What is the difference between ddl,dml and dcl commands?

1153


What can be used instead of trigger?

1205


Do you know what are different types of replication in sql server?

1153


What is a database in ms sql server?

1103