What is the difference between Where and Having Clause
Answer Posted / njadav
Where Clause:
1)WHERE clause can be used without GROUP BY clause.
2)WHERE clause select rows before grouping.
3)WHERE clause can not contain aggregate functions.
4)WHERE clause can operate individual row.
5)It is more fast.
Having Clause:
1)HAVING clause can not be used without GROUP BY clause.
2)HAVING clause select rows after grouping.
3)HAVING clause can contain aggregate functions.
4)HAVING clause can operate group of row.
5)It is much slow.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Define buffer pool.
What is the maximum No of rows per page?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the role of schema in the db2 database?
What is rct?
Describe major components of db2?
What is runstats utility in db2?
What is load replace in db2?
What is cascading rollback?
What is the maximum number of columns in a db2 table?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Mention the definition of cobol in varchar field.
What is db2 plan table?
What is a dbrm in db2?