Answer Posted / t.lakshmi
count - It returns the non null values
count(*) - It returns the null values and duplicate values
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Explain Capacity planning to create a database? and how to monitor it?
How to provide values to user defined function parameters?
What are the filtered indexes?
How can we rewrite sub-queries into simple select statements or with joins?
What are the different editions available in sql server 2000?
How to execute function in stored procedure sql server?
What is self contained multi valued query?
What is the sql server 2000 version number?
Explain how would you store your query in an SSRS report or a Database server?
What is the architecture of ms sql reporting service?
What is nolock?
What is difference between order by and group by?
Which is the latest version of sql server and when it is released?
How can we solve concurrency problems?
What is table valued function and scalar valued functions?
