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

Answer / kushi

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

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.

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

Answer / karthik

both will be display same record count.

What is data modeling and Reterminal integrity?

0 Answers  

What are indexes in ms sql server?

0 Answers  

What number sorts of privileges are accessible in sql?

0 Answers  

Can we delete data from a view?

0 Answers  

Write a code to select distinct records without using the DISTINCT keyword.

0 Answers   Aspiring Minds,

Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  

what are the advanced features in sql 2008?

2 Answers   Wipro,

how to do partition in sqlserver

0 Answers   TCS,

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

How data can be copied from one table to another table?

0 Answers  

How to create a new schema in a database?

0 Answers  

can you any body tell me the difference between candidate key and primary key

4 Answers