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 / manisha

count fetches non-null value from out of a query but count
(*) includes null values also.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is checksum in sql server.........???

1741


Is resultset an interface?

1035


What are the different authentication modes in sql server?

1164


How do I start sql server agent automatically?

1018


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1794


What is a dbms wizard?

1068


Mention the differences between sql server and mysql.

1072


What is difference between rownum and rowid?

954


Which trace flags are enabled in sql server?

1067


what is the difference between Delete and Truncate command in SQL

1194


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1993


how to create “alternate row colour”?

152


What is @@error in sql?

1104


What is triggers and its types?

1064


What is database black box testing?

1068