'Count': Counts the number of non-null values. 'Count(*)�

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

Question Posted / guest

Answer Posted / guest

'Count': Counts the number of non-null values.
'Count(*)': Counts the number of rows in the table,
including null values and duplicates.

Is This Answer Correct ?

42 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Why do we use trigger?

915

What is the use of keyword with encryption. Create a store procedure with encryption?

899

How to locate and take substrings with charindex() and substring() functions?

942

What is the use of for clause?

1033

Write a query for primary key constraint with identity key word?

971

Define cross join in sql server joins?

963

Explain the steps to use transact-sql cursor?

952

What triggers long term care?

991

what is sql server? : Sql server database administration

926

How to create user messages with print statements in ms sql server?

939

What is full outer join in sql server joins?

981

Explain full-text indexing?

914

What is multi-statement table-value user-defined function?

932

Can we deploy SSRS reports on our personal website?

162

What is update_statistics command?

1017