What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 30200 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / santosh pashupatimath
Having clause is used before aggregation and where clause is
used before aggregation
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is standby servers? Explain types of standby servers.
List out the different types of locks available in sql server?
What are different types of constraints?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What kind of problems occurs if we do not implement proper locking strategy?
Why should you use or avoid select * statements?
How do I find query history in sql server?
Can we shrink data file in sql server?
Can we do dml on views?
Explain “row_number()” in sql server with an example?
How to convert numeric expression data types using the cast() function?
When should you use an instead of trigger?
what is the difference between openrowset and openquery?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Why and when do stored procedure recompile?
