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 is difference between index and primary key?

1096

do you know how to configure db2 side of the application? : Sql server database administration

1039

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1142

How will you hide an attribute? : sql server analysis services, ssas

952

How self join is different from outer join?

1113

How to apply filtering criteria at group level with the having clause in ms sql server?

993

Define Wed Edition in SQL Azure?

100

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1056

Explain what is raid and what are different types of raid levels?

1015

How to create an index on an existing table in ms sql server?

975

What are the steps you will take to improve the performance of a poor performing query?

969

How to generate create view script on an existing view?

982

Can we deploy SSRS reports on our personal website?

168

Explain user defined views?

952

How to return the date part only from a sql server datetime datatype?

1095