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

Does partitioning improve performance sql server?

987

What is collation sensitivity? Explain different types.

1017

What is the maximum row of a size?

1023

What language is sql server written in?

1045

What do you mean by collation recursive stored procedure?

1067

what are the different types of replication you can set up in sql server? : Sql server database administration

1032

What is primary key index?

987

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

994

How can sql server instances be hidden? : sql server security

1159

How to loop through the result set with @@fetch_status?

1362

Explain datetimeoffset data type in sal server 2008?

922

What are the system database in sql server 2008?

1040

What is inner join? Explain with an example?

1233

How to create an inline table-valued function?

982

Can a synonym name of a table be used instead of a table name in a select statement?

1050