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 / rajeeva tripathi

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

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are magic tables in sql server?

1043


What is perspective, have you ever created perspective? : sql server analysis services, ssas

958


What is the use of keyword with encryption.

1081


Explain about Normalization?

1117


Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1072


What is a derived table?

985


Tell me what is fill factor?

1007


What is an etl file?

1004


What are the basic functions for master, msdb, model, tempdb databases?

1091


What are the steps to insert a table?

989


on line cluster can we make if yes tell me the procedure

2067


What is wide table?

1012


What is the difference between index seek vs. Index scan?

1059


What is the rdl file?

141


What is a trigger what are the advantages of trigger?

1059