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 to create percentile function?
What is the correct order of the logical query processing phases?
What is the difference between createstatement and preparedstatement?
What is the use of for clause?
What are the differences between DDL, DML and DCL in SQL?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What happens to a trigger with multiple affected rows?
According to you what goes into making the best database administrator? : sql server database administration
What samples and sample databases are provided by microsoft?
What is a raid and what are different types of raid configurations?
What is a collation?
Explain few examples of RDBMS?
Why we use functions in sql server?
List the types of recovery model available in sql server?
What are policy management terms?
