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
How do you rebuild an identity column?
Can we use where clause in union?
How to create a stored procedure with a statement block in ms sql server?
Where is localdb stored?
how many triggers you can have on a table? : Sql server database administration
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Explain differences between web edition and business edition?
Explain the properties of sub-query in sql server?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
How except clause is differs from not in clause?
Why would you use sql agent?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is the tcp/ip port on which sql server runs?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?