What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / srinivas
HAVING CLAUSE is used for evaluating a condition with an
aggregate function, i.e., GROUP BY whereas WHERE CLAUSE is
used for general conditions.
| Is This Answer Correct ? | 35 Yes | 4 No |
Post New Answer View All Answers
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What types of replication are supported in sql server?
What are triggers? How do you invoke a trigger on demand?
Mention the different types of triggers?
What is named calculation? : sql server analysis services, ssas
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Explain what are various ways to enhance the ssrs report?
Is it true, that there is no difference between a rule and a check constraint?
What does REVERT do in SQL Server 2005?
Explain the difference between cross join and full outer join?
What is sqlcmd?
What is service broker?
What are parameterized reports? What are cascading parameters in ssrs reports?
What is the maximum size of column in sql server?
Explain filtered indexes benefits?