What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 30202 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 the different types of subquery?
what is the difference between openrowset and openquery?
Can you index views?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How do I find the sql server version?
Can we do dml on views?
Equi join and non equi join is possible with sql server?
How can you append an identity column to a temporary table?
Explain system functions or built-in functions? What are different types of system functions?
How to enter binary string literals in ms sql server?
What are the kinds of subquery?
What are the properties of the transaction?
Why and when do stored procedure recompile?
What is the difference between for xml raw and for xml auto?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
