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

What function does a database engine serve in the sql server?

1043

After removing a table from database, what other related objects have to be dropped explicitly?

1064

What are distributed partitioned views?

1083

What are the components of dbms?

954

What is the federation in sql azure?

What is microsoft sql server?

979

what is bit datatype? : Sql server database administration

924

What happens if you delete a table that is used by a view?

993

Do you know nested transaction?

963

What happens on checkpoint?

1028

What is collation?

1146

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1068

What are the advantages of passing name-value pairs as parameters?

1168

What is a view in sql?

979

explain different types of cursors? : Sql server database administration

1094