Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Where and Having Clause
- 7 Answers
- 30742 Views
- IBM, iFlex, I also Faced
- E-Mail Answers
Answer Posted / narendra
Both are used to filter the rows but
where is used to filter the rows on single row functions and
having is used to filter the rows on group functions or aggregate functions.
one more thing i would like to mention is
having can be used without group by
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What is runstats db2?
Who uses db2?
What is copy pending status in db2?
What does sqlcabc has?
List out the three types of page locks that can be held.
What is cursor stability in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
can we view the access paths created by dbrm ? how ? thx
What is node in db2?
List out the data types available.
List out the buffer pools in db2
What is the use of predicate?
What is query_cache_limit?
What are iseries servers?
What is the role of union all and union
