Answer Posted / vijay dev saxena
Count(expr) -> returns the number of records in the table
where the expr is not null in the particular column.
Count(*) -> returns the number of all records in the table.
(including duplicates and those with nulls)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Benefits of Stored Procedures?
Can you index views?
What is an index in sql?
Why do we use non clustered index?
Can group by be used without aggregate functions?
How to provide default values to stored procedure parameters?
Define indexes?
What are data resources?
How to create an inline table-valued function?
What is 2nf normalization?
What is the default fill factor value?
What is intellisense?
What are window functions in sql server?
Tell me what is a linked server?
What is table constraint?