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

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

938

Explain the dbcc pintable command when would you use it?

968

What is normalization 1nf 2nf 3nf?

1109

What is difference between materialized view and view?

953

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2114

What is the latest version of microsoft sql server?

1116

What are the dis_advantages of stored procedures, triggers, indexes?

2273

How to use group functions in the select clause in ms sql server?

1119

What is the usage of the sign function?

1193

Which language rdl files made of?

141

List some advantages and disadvantages of stored procedure?

1063

How to start sql server browser service?

1181

What is a covering index?

1042

What is the datatype of rowid?

963

What is indexing explain it with an example?

1070