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...

What is the difference between the following two sql
statements
select count(*) from <tablename>
select count(col_name) from <tablename>

Answer Posted / karthik

both will be display same record count.

Is This Answer Correct ?    2 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by the denormalisation?

1018


Define full outer join?

1010


What causes index fragmentation?

1045


Explain the truncate command? : SQL Server Architecture

1230


How to use copy and concatenate commands in SQL?

1192


If we delete pack Spec what will be the status of pack Body ?

1522


What is global temp table?

1045


Explain the Ways to improve the performance of a sql azure database?

84


What is a data collection table?

1051


Where can you add custom error messages to sql server?

1161


When cursors are useful?

1168


what is a schema in sql server 2005? : Sql server database administration

1081


why would you call update statistics? : Sql server database administration

1156


Explain the different types of joins?

1042


User wants only to display only pdf as export option in report manager. How to achieve this?

269