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

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

Question Posted / anand

13 Answers
28268 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are data resources?

854

Which tcl commands are available on the sql server?

1018

How to create a testing table with test data in ms sql server?

1016

What are transactions and its controls?

1005

Call by value and call by reference in procedure and function, with NOCOPY.

1247

Can sql server be linked with other servers like oracle?

905

How to perform backup for certificates in sql server? : sql server security

1026

What do you mean by tablesample?

1035

Can I use sql azure as a backup with log shipping or database mirroring?

156

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1991

Explain try...catch with sql server?

982

explain extended properties

929

What are the different types of sub-queries?

997

What are the kinds of subquery?

951

How to create median function?

152