What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26294 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
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 the log shipping?
Difference between 2NF &3NF ?
What are a scheduled jobs or what is a scheduled tasks?
What are rows and columns?
What is autocommit mode in sql server?
How to use transact-sql statements to access the database engine?
Will the writetext statement activate a trigger?
What is read uncmmited?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What authentication modes does sql server support?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Explain important index characteristics?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What is a benefit of using an after insert trigger over using a before insert trigger?
Determine when an index is appropriate?
