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 / pradip jain

COUNT(column_name): COUNT THE NUMBER OF ROWS EXCLUDING NULL
VALUES BUT INCLUDING DUPLICATES

COUNT(*):COUNT THE NUMBER OF ROWS INCLUDING NULL VALUES AND
DUPLICATES.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between varchar and nvarchar?

982


What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1199


Explain transaction server distributed transaction?

1036


do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

1042


How are the exceptions handled in sql server programming?

1118


What are the rendering extensions of ssrs?

160


what stored procedure can you use to display the current processes? : Sql server administration

1053


Do you know query execution plan?

1263


What is a trigger in sql server?

1225


How to call a function from a stored procedure in SQL Server ?

1081


Do you know the cursor types?

1202


what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1178


How do I partition a table in sql server?

1098


What is the contrast between sql and pl/sql?

1198


Can a table be moved to different filegroup?

1025