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
28231 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 buffer cash and log cache in sql server?

1051

How to delete database objects with "drop" statements in ms sql server?

1030

Where sql server user names and passwords are stored in sql server? : sql server database administration

992

What are the aggregate and scalar functions?

990

Define candidate key, alternate key, and composite key.

866

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1163

Explain rdbms?

977

Tell me about the approaches which you used to counter the DI problems.

1266

Do you know hot add cpu in sql server 2008?

894

What command is used to rename the database?

945

What is the difference between char and varchar2 datatype in sql?

1004

What is the contrast between sql and mysql?

1046

What are the differences between sql server and mysql.

1019

How you can get the list of largest tables in a database?

940

Can we write a distributed query and get some data which is located on other server and oracle database?

1172