What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / manisha
Having clause is used to filter group while WHERE CLAUSE
is used to filter rows.
Having clause can have aggregate function but WHERE CLAUSE
cannot have aggregate function.
Is This Answer Correct ? | 22 Yes | 9 No |
Post New Answer View All Answers
What is built-in function?
Does sql server use t sql?
Explain a join?
What is isnull() operator?
What is query optimization process?
What are the two modes of authentication in sql server?
What is meant by indexing?
how many triggers you can have on a table? : Sql server database administration
What is lock escalation and what is its purpose?
What is the sql profiler?
What is merge?
How to replace the Query Result 'Null Value' with a text ?
Explain features and concepts of analysis services?
what types of replication are supported in sql server? : Sql server database administration
How do I install sql server?