COUNT(column_name): COUNT THE NUMBER OF ROWS EXCLUDING NULL VALUES BUT INC

The Difference between 'Count' and 'Count(*)'

Question Posted / pradip jain

13 Answers
28766 Views
I also Faced
E-Mail Answers

Answer Posted / pradip jain

COUNT(column_name): COUNT THE NUMBER OF ROWS EXCLUDING NULL
VALUES BUT INCLUDING DUPLICATES

COUNT(*):COUNT THE NUMBER OF ROWS INCLUDING NULL VALUES AND
DUPLICATES.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is cross join in sql server joins?

1142

Explain various On-Delete options in a DB table. Which is the default option?

1468

What are the events recorded in a transaction log?

1000

What are trace flags?

1032

How do I delete a sql server database?

1045

What are 3 ways to get a count of the number of records in a table?

1078

Why olap is used?

974

Disadvantages of the indexes?

1125

How to download microsoft sql server 2005 express edition?

1047

How many replicas are maintained for each SQL Azure database?

142

what is a schema in sql server 2005? : Sql server database administration

1031

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1025

Can a table be created inside a trigger?

968

What are the types of dml?

981

What is the most common type of join?

989