What is the difference between Where and Having Clause
Answer Posted / s
WHERE filters the rows based on the predicate.
HAVING filters a group of rows based on the GROUP BY colums.
| Is This Answer Correct ? | 48 Yes | 10 No |
Post New Answer View All Answers
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is meant by explain?
Is db2 a mainframe database?
Is ibm db2 open source?
what is utility for parm lib
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What are the contents of dclgen?
What is the role of the data page in the db2 database?
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 ?...
What is netezza database?
What is an instance in db2?
What is the physical storage length of date data type?
What is the physical storage length of timestamp data type?
How do I change the column size in db2?
What are packages in db2?