Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29169 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
Can two tables have the same primary key?
Write down the syntax and an example for create, rename and delete index?
How do you delete a trigger?
What is difference between index and primary key?
How to get the definition of a stored procedure back?
Is mysql better than sql server?
What is the ‘fillfactor’?
Can we add a cpu to sql server?
Explain how to maintain a fill factor in existing indexes?
What is Extended user-defined?
What are parameterized reports? What are cascading parameters in ssrs reports?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is an expression in ms sql server?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
Mention the 3 ways to get a count of the number of records in a table.
