Answer Posted / rajeeva tripathi
count - It returns the non null values
count(*) - It returns the null values and duplicate values
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is sub query and its properties?
How many triggers you can have on a table?
How do I perform an unattended install of sql server 2000?
List out the difference between union and union all in sql server?
What is microsoft sql server?
How to delete database objects with "drop" statements in ms sql server?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What types of replication are supported in sql server?
How to create percentile function?
What are commonly used odbc functions in php?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What is the difference between for trigger and after trigger?
What is the purpose of the master database?
Mention the differences between sql server and mysql.
What is normalization? What number of normalization shapes are there?
