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
What are the types of subquery?
How many replicas are maintained for each SQL Azure database?
How to edit table in sql server 2017?
Can we call future method from trigger?
Can I work with several databases simultaneously? : sql server management studio
What stored by the model?
Can you name a few encryption mechanisms in sql server?
Explain system rowset functions?
What is the difference between clustered and non-clustered indexes in ms sql server?
How can we delete a table in sql server?
What is sql language?
What is the difference between a primary key and a unique key? Are they the same?
Which is the latest version of sql server and when it is released?
What is the recursive stored procedure in sql server?
What is optimistic concurrency?