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

explain extended properties

973

Tell me what is the stuff and how does it differ from the replace function?

967

Sql server reporting services vs. Crystal reports.

131

How can you fetch alternate records from a table?

946

When is update_statistics command used?

1024

Which tools are available to manage SQL Azure databases and servers?

115

What do you mean by the term 'normalization'?

1178

Can a database be shrunk to 0 bytes, if not, why?

1080

What are the advantages of the mirroring?

1059

What are the types of resultset?

952

Can a unique index be created on a column, which contains null?

906

What is index fragmentation in ms sql server?

1062

How to search for a string in all stored procedure in sql server?

980

To which devices can a backup be created and where should these devices be located? : sql server management studio

1023

please differentiate between delete and truncate?

975