Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29643 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / manisha
Having clause is used to filter group while WHERE CLAUSE
is used to filter rows.
Having clause can have aggregate function but WHERE CLAUSE
cannot have aggregate function.
| Is This Answer Correct ? | 22 Yes | 9 No |
Post New Answer View All Answers
What is BLOCK statements in SQL?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is a hint?
Explain log shipping?
List out the different types of locks available in sql server?
What is sub-query in sql server?
How to create indexed view?
Tell me can we use custom code in ssrs?
What is a transaction and why is it important?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What is sql language?
How to find out the list schema name and table name for the database?
What can be used instead of trigger?
What is dynamic cursor in SQL SERVER?
What is Extended user-defined?
