Answer Posted / sachin rathi
Count(column name or exp) returns the no. of records for a
specific/particular column of table excluding null values
whereas Count(*) returns all the rows/records in the table
including duplicated and null values
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How do I uninstall sql server 2014?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What is the difference between set and select?
What is the difference between SQL notification and SQL invalidation?
What are distributed partitioned views?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Do you know how to store and query spatial data?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What is format parameter in ssrs?
Explain what are the basic functions for master, msdb, model, tempdb databases?
How to find the list of fixed hard drive and free space on server?
How we can refresh the view?
What is a domain constraint give an example?
Mention the uses of stored procedures.
Explain different types of index?
