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 |
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What are “lost updates”?
What is the difference between distinct clause and group by clause?
What are the different SQL Server Versions you have worked on?
What is partition, how will you implement it? : sql server analysis services, ssas
What is amo? : sql server analysis services, ssas
Explain transaction server isolation?
What is Pointer ?
3 Answers Cap Gemini, CarrizalSoft Technologies,
If a table does not have a unique index, can a cursor be opened on it?
What do you mean by an execution plan? Why is it used? How would you view it?
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005
What are difference between Cluster index and Non-Cluster index?