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
28635 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 are pages and extents? : SQL Server Architecture

1003

What is triggers in ms sql server?

1093

Explain what is cte (common table expression)?

1112

Distinguish between nested subquery and correlated subquery?

1021

What is ddl command?

957

How to reaname table name without using sp_Rename in sql server..?

973

What are difference between Cluster index and Non-Cluster index?

1059

What is dml command?

938

what type of index will get created after executing the above statement? : Sql server database administration

961

What is the library index called?

1041

Write a SQL query to make a column as unique?

1015

What happens when converting big values to numeric data types?

1100

What stored by the msdb? : sql server database administration

988

How to use linked server?

1165

What is a partition key?

933