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
Explain what are magic tables in sql server?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What is the use of keyword with encryption.
Explain about Normalization?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
What is a derived table?
Tell me what is fill factor?
What is an etl file?
What are the basic functions for master, msdb, model, tempdb databases?
What are the steps to insert a table?
on line cluster can we make if yes tell me the procedure
What is wide table?
What is the difference between index seek vs. Index scan?
What is the rdl file?
What is a trigger what are the advantages of trigger?