Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29650 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 index. What are the types?
How do I schedule a sql server profiler trace?
What are magic tables in sql server?
What are the different authentication modes in sql server?
Explain the microsoft sql server delete command? : SQL Server Architecture
How to transfer data from a cursor to variables with a "fetch" statement?
List out the different types of locks available in sql server?
Explain how to use linked server?
How do I find information about the install locations for the various instances running on a computer?
What are the ways available in sql server to execute sql statements?
What is Lock table in SQL?
How to sort query output in descending order in ms sql server?
What is log ldf?
What does top operator do?
How can we rewrite sub-queries into simple select statements or with joins?
