What is the difference between the following two sql
statements
select count(*) from <tablename>
select count(col_name) from <tablename>
Answers were Sorted based on User's Feedback
Answer / debasis
select count(*) from <tablename> returns the number of rows
in the table.
select count(col_name) from <tablename> return number
values in the column (Ignores null value in the colum). For
example if we execute the following 2 queries then
select count(*) form emp
select count(comm) form emp
The result will be
14
4
Is This Answer Correct ? | 34 Yes | 7 No |
Answer / kushi
for the First Qry,result is "No.of records"
for the second Qry,result is "No.of records for particular
columnname"
Is This Answer Correct ? | 17 Yes | 0 No |
Answer / sandeep
select count(*) from <tablename>
- return number of records from table
select count(col_name) from <tablename>
- return number of records where col_name is NOT NULL
- Null value is eliminated by an aggregate or other SET
operation.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sql2000
There seem to be a problem with the solutions provided by
the above.
Both the counts should provide the same result which is the
no of rows in the table.
count (*) will result in a bigger table scan than count
(col_name) hence its advisable to use count(1) while
calculating the count for a table.
Correct me if I am wrong...:)
Is This Answer Correct ? | 1 Yes | 3 No |
What are secondary xml indexes?
what is mean by crystal repoart? ahere we will mainly use that?
Why do you want to join software field as you have done your BE in Electronics?
What are the underflow and overflow behaviors on float literals?
How to sort query output in descending order in ms sql server?
Explain magic tables in sql server?
What does normalization do to data?
how to get max salary with employee number by using one select query and max function ??
How can I create a report based on a query? : sql server management studio
what is advantages in sql 2005 over sql 2000?
How do I make a resultset scrollable?
What does <> symbol mean?