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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / srikanth

Answers were Sorted based on User's Feedback



What is the difference between the following two sql statements select count(*) from <tablena..

Answer / debasis

select count(*) from <tablename> returns the number of rows
in the table.

select count(col_name) from <tablename> return number
values in the column (Ignores null value in the colum). For
example if we execute the following 2 queries then

select count(*) form emp
select count(comm) form emp

The result will be
14
4

Is This Answer Correct ?    34 Yes 7 No

What is the difference between the following two sql statements select count(*) from <tablena..

Answer / kushi

for the First Qry,result is "No.of records"
for the second Qry,result is "No.of records for particular
columnname"

Is This Answer Correct ?    17 Yes 0 No

What is the difference between the following two sql statements select count(*) from <tablena..

Answer / sandeep

select count(*) from <tablename>
- return number of records from table


select count(col_name) from <tablename>
- return number of records where col_name is NOT NULL
- Null value is eliminated by an aggregate or other SET
operation.

Is This Answer Correct ?    5 Yes 0 No

What is the difference between the following two sql statements select count(*) from <tablena..

Answer / sql2000

There seem to be a problem with the solutions provided by
the above.

Both the counts should provide the same result which is the
no of rows in the table.
count (*) will result in a bigger table scan than count
(col_name) hence its advisable to use count(1) while
calculating the count for a table.

Correct me if I am wrong...:)

Is This Answer Correct ?    1 Yes 3 No

What is the difference between the following two sql statements select count(*) from <tablena..

Answer / karthik

both will be display same record count.

Is This Answer Correct ?    2 Yes 12 No

Post New Answer

More SQL Server Interview Questions

what is advantages in sql 2005 over sql 2000?

4 Answers  

Are semicolons required at the end of sql statements in sql server 2005?

0 Answers  

What is function of CUBE ?

0 Answers   HCL,

What is cdc in sql server?

0 Answers  

Can you explain various data region available in ssrs with their use?

0 Answers  

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

0 Answers  

How do you rename a table in sql server?

0 Answers  

Is foreign key unique?

0 Answers  

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

0 Answers   TCS,

Explain what is “asynchronous” communication in sql server service broker?

0 Answers  

What is a sql join?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories