both will be display same record count.

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

Question Posted / karthik

Answer Posted / karthik

Is This Answer Correct ?

2 Yes

12 No

Please Help Members By Posting Answers For Below Questions

Write a query for primary key constraint with identity key word?

972

what is the difference between Delete and Truncate command in SQL

1084

How to write a query with an inner join in ms sql server?

997

What is resource governor?

926

What are points to remember while using the fillfactor argument?

907

What is the synonym of join?

895

What is bit data type? What's the information that can be stored inside a bit column?

874

How to find index size for each index on table?

960

What is a matrix in ssrs?

135

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

882

What are the advantages of partitioning?

1045

Tell me about normalization in DBMS.

947

What is the benefit of normalization?

1019

What are the differences between clustered and non-clustered index?

954

how many layers of tcp/ip protocol combined of? : Sql server database administration

937