What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 30189 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / guest
Having Clause is basically used only with the GROUP BY
function in a query. WHERE Clause is applied to each row
before they are part of the GROUP BY function in a query.
| Is This Answer Correct ? | 68 Yes | 4 No |
Post New Answer View All Answers
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How do I find the sql server version?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are different types of constraints?
What is normalization and what are the advantages of it?
What is a coalesce function?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is sql server query analyzer?
How can we solve concurrency problems?
what is the difference between openrowset and openquery?
What is sql or structured query language?
what is spatial nonclustered index
What is acid mean in sql server?
Explain “row_number()” in sql server with an example?
Can you index views?
