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

Where are SQL server users names and passwords are stored in sql server?

1273

Is truncate autocommit?

938

What are the advantages dts has over bcp?

1000

What is a select query statement in ms sql server?

1077

How to create median function?

164

What is global temp table?

996

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1022

what are user defined datatypes? : Sql server database administration

966

Can a table have 2 foreign keys?

905

What gets stored inside msdb database?

1247

What is query processing?

942

How to check status of stored procedure in sql server?

988

Explain candidate key, alternate key, and composite key?

1003

Explain the different types of joins?

997

What are commonly used mssql functions in php?

1081