Answer Posted / vijay dev saxena
Count(exp): Counts the number of rows excluding null values.
Count(*) : Counts the number of rows including null and
duplicates records.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is nolock?
Why we use functions in sql server?
What is table valued function and scalar valued functions?
What is the difference between the application object and session object?
What is subquery? Explain the properties of a subquery?
How do you create an execution plan?
What is the use of sign function?
What do you understand by user-defined function in the sql server?
How do I create a trace in sql server?
What is the sql case statement used for?
Explain about Views?
Explain what stored procedure sp_replcounters is used for? : sql server replication
How to make a remote connection in a database?
What command is used to delete a table from the database in the sql server and how?
Does partitioning help performance?