Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29948 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 is an expensive query?
What is the function of inner join?
What is store procedure?
Explain the dirty pages?
How to connect Azure federated root database and apply federation in entity framework?
Do you know what is replace and stuff function in sql server?
How to add the custom code in Report?
What is data modeling and Reterminal integrity?
How to find out what is the default collation in a database?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Explain the first normal form(1nf)?
What happens if time-only values are provided as date and time literals?
How to make remote connection in database?
Can you explain different types of locks in sql server?
What do you mean by recursive stored procedure?
