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 |
Do you know sql server 2008 introduces automatic auditing?
what is difference between view and Dip.
How to change the system date and time from SQL Plus Terminal ?
What is the default isolation level of the sql server database?
Can a function call a stored procedure in sql server?
In what version of sql server were synonyms released?
What is BCNF? How is it better than 2NF & 3NF?
What are the differences between DDL, DML and DCL in SQL?
0 Answers ABB, Aspire, Infogain,
What is the datatype returned by count(*)
22 Answers 247Customer, Asian CERC,
how to find number of columns in a table in sql server 2000 and 2005 also
What is the order by used for?
Write a program using SQL queries to find a unique entry in a table.