What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 30198 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
How to connect php with different port numbers?
What is normalization and what are the advantages of it?
How can we solve concurrency problems?
what is the difference between openrowset and openquery?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Explain “row_number()” in sql server with an example?
Is it possible to have clustered index on separate drive from original table location?
Can we shrink data file in sql server?
Can you index views?
How do I find the sql server version?
Why should you use or avoid select * statements?
How efficient you are in oracle and SQL server?
What kind of problems occurs if we do not implement proper locking strategy?
What is standby servers? Explain types of standby servers.
Can sql servers link to other servers like oracle?
