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
Explain database normalization?
What is a fan-out query in SQL Azure?
How to create user messages with print statements in ms sql server?
What are sql server functions?
What is a result set object returned by odbc_exec()?
Explain the properties of a relational table?
What are the types of resultset?
What is a select query statement in ms sql server?
What is lock escalation? : sql server database administration
Which is the best place or learning center for MS SQL?????In Bangladesh?????
what stored procedure can you use to display the current processes? : Sql server administration
Explain the collation?
Do you have any idea about the tcl commands?
How to identify current user in ssrs report?
What is the definition for sql server 2000?