Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29676 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 constraints? Explain different types of constraints? : Sql server database administration
what are acid properties? : Sql server database administration
Explain ranking functions?
Does a full backup include transaction log?
What are the different types of Indexes available in SQL Server?
Explain how does the report manager work in ssrs?
Where in ms sql server is ’100’ equal to ‘0’?
How to attach adventureworkslt physical files to the server?
What is bcp? When does it used?
What is difference between drop truncate and delete?
What is the xml datatype?
What is a periodical index?
Explain index in sql server?
Do you know how to store and query spatial data?
Explain active/passive and active/active cluster configurations?
