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

Describe the functionalities that views support.

1099

Is null vs coalesce?

880

Explain primary key, foreign key and unique key?

992

How to add additional conditions in SQL?

1022

What is microsoft sql server?

973

Define normalisation?

1114

What is a mixed extent?

1021

Explain ms sql server reporting services vs crystal reports?

916

How to update multiple rows with one update statement in ms sql server?

1203

What is a virtual table in sql?

996

What is the difference between online clustering and Offline clustering?

2416

Explain what are magic tables in sql server?

994

Do you know what is sql injection?

998

What is the purpose of a table?

959

What is replication and database mirroring?

1047