The Difference between 'Count' and 'Count(*)'
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vijay dev saxena
Count(exp): Counts the number of rows excluding null values.
Count(*) : Counts the number of rows including null and
duplicates records.
Is This Answer Correct ? | 13 Yes | 0 No |
In SQL Server 2000,
Query:
------
select count from employees
Answer:
------
invalid column name 'count'
In SQL Server 2000,
Query:
------
select count(*) from employees
Answer:
-------
No column name
----------------
1. 20
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / t.lakshmi
count - It returns the non null values
count(*) - It returns the null values and duplicate values
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / vijay dev saxena
Count(expr) -> returns the number of records in the table
where the expr is not null in the particular column.
Count(*) -> returns the number of all records in the table.
(including duplicates and those with nulls)
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sachin rathi
Count(column name or exp) returns the no. of records for a
specific/particular column of table excluding null values
whereas Count(*) returns all the rows/records in the table
including duplicated and null values
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / manisha
count fetches non-null value from out of a query but count
(*) includes null values also.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / harish sharma
Count(column_name) returns the number of records in the
table where the column value is not null for the particular
column.
Count(*) returns the number of all records in the table.
(including duplicates and those with nulls)
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / rajeeva tripathi
count - It returns the non null values
count(*) - It returns the null values and duplicate values
Is This Answer Correct ? | 3 Yes | 0 No |
When we can say that is in BCNF?
Explain magic tables in sql server?
How to create Clustered Primary Key to table?
What is the difference between a function and a stored procedure?
Explain nested trigger in sql?
How to select Distinct columns from the table, table having 20 columns and i want all coulmns
How to create a scrollable cursor with the scroll option?
What are the advantages of user defined function?
What is nolock hint in sql server 2008
Explain following error properties?
How to create a local temporary stored procedure?
Explain isolation levels that sql server supports?