'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

Name few endpoints exposed by ssrs 2012?

330

Do you know sql server 2008 introduces automatic auditing?

708

How do you start single user mode in clustered installations?

741

Write a program using SQL queries to find a unique entry in a table.

745

Explain intellisense for query editing

783

What is a ddl statement?

705

How to change the name of a database user?

759

List out different types of normalizations in sql server and explain each of them?

732

1 01 101 01010

1827

What is a select query statement in ms sql server?

798

What do you do in data exploration

732

Which sql server is best?

756

how you can deploy an ssrs report?

141

What is use of except clause?

858

What is the difference between cartesian product and cross join?

658