Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29183 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
Explain about protocol layer present in SQL server?
How to use clusters?
What are “lock” hints?
How does normalization work?
What is clustered index
How can you append an identity column to a temporary table?
How to throw custom exception in Stored Procedure?
What is sql language?
How to delete duplicate rows in sql server?
How to create a view using data from another view?
How to disable a login name in ms sql server?
Do you know what is lock escalation?
What is use of dbcc commands?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
