Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Where and Having Clause
- 7 Answers
- 30521 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 the sqlcode -501
What is nvl in db2?
i want to maintain uniqueness on pdf without make lf??????????
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Explain package in db2 and its advantages?
What is scrollable cursor in db2?
Comment whether the cursor is closed during commit or not.
What is dbrm? What it contains? When it will be created?
What is db2 purescale?
What is a db2 table?
What is meant by union and union all?
What is check constraint. Explain with example.
What are the full forms of spufi and dclgen and why are they used?
How to run db2 command in windows?
What is buffer pool and list some of them?
