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

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

Question Posted / kushi

Answer Posted / kushi

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

Is This Answer Correct ?

17 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How is table type constraint applied to a table?

979

Can you insert NULL in unique column?

1161

what is a live lock? : Sql server database administration

955

What is the use of keyword with encryption. Create a store procedure with encryption?

960

Tell me when is the update_statistics command used?

1112

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

950

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

982

What are types of storage modes? : sql server analysis services, ssas

1042

What are different backups available in sql server?

1072

What is temporal data type?

921

What is the use of stored procedure?

940

How to enter date and time literals in ms sql server?

1016

How to delete a login name in ms sql server?

1075

How to verify a login name with sqlcmd tool?

1221

How to grant a permission in ms sql server using "grant execute" statements?

1093