What is the difference between Where and Having Clause
- 7 Answers
- 27521 Views
- IBM, iFlex, I also Faced
- E-Mail Answers
Answer Posted / kums
Aso we can say that, WHERE filters the rows based on the
predicate. HAVING fill workd along with aggragate function.
| Is This Answer Correct ? | 21 Yes | 10 No |
Post New Answer View All Answers
is it compulsory commitment control in journal?
what is the sqlcode -501
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Is schema the same as database?
What are the 2 sqlcodes that are returned?
What is view db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Before you give the explain statement, what are the prerogatives?
What are the bind parameters ibm db2?
How do I change the column size in db2?
What is rct?
Explain correlated sub-queries.
What does reorg do in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Give the name of some fields form sqlca.
