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

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

Question Posted / anand

Answer Posted / anand

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the purpose of grouping data in a report?

1013

Can sql servers linked to other servers like oracle?

1006

Do you know what are the ways available in sql server to execute sql statements?

1082

What is GUID in sql server?

1223

What is the difference between count and distinct count?

928

what is an index? : Sql server database administration

1022

How can I tell if sql server is 32 or 64 bit?

1010

What is etl - extraction, transformation, and loading?

958

What is sql server locking?

1034

What is a benefit of using an after insert trigger over using a before insert trigger?

1032

What are the general features of sql server management studio? : sql server management studio

1131

How to handle error or exception in sql?

1030

What are dml (data manipulation language) statements in ms sql server?

1022

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

1030

Explain about extended stored procedure?

991