Answer Posted / 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 |
Post New Answer View All Answers
Where can you find the error log information? : sql server database administration
What are information schema views?
What are the types of subscriptions in SQL Server replication?
What is transaction server consistency?
What is the server name for sql management studio?
How can I create a new template for import ? : sql server management studio
What are the approximate numeric data types?
How to create a testing table with test data in ms sql server?
Do you know what is lock escalation?
What is the most common type of join?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is the difference between ddl,dml and dcl commands?
What can be used instead of trigger?
Do you know what are different types of replication in sql server?
What is a database in ms sql server?