What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26374 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / sudheer gowlikar
Having clause Specifies a search condition for a group or
an aggregate. HAVING can be used only with the SELECT
statement. HAVING is typically used in a GROUP BY clause.
When GROUP BY is not used, HAVING behaves like a WHERE
clause.
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
What are points to remember while using the fillfactor argument?
Can you please explain the difference between primary keys and foreign keys?
What are the joins in sql server? : sql server database administration
What is the ‘fillfactor’?
What is create statement?
What is user-defined multi-statement table-valued function?
List the various tools available for performance tuning?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What are the instances when triggers are appropriate?
In how many ways you can invoke ssrs reports?
What are the advantages of user defined function?
What are ddl triggers and types of ddl trigger?
Explain concepts of analysis services?
What is the difference between substr and charindex in the sql server?
Do you think BCNF is better than 2NF & 3NF? Why?
