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
What db2 400?
How to view db2 table structure?
How can we retrieve the total number of records in RPG & CLLE?
How do you pull up a query which was previously saved in qmf?
How is a typical db2 batch pgm executed?
What do you mean by storage group (stogroup)?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Where can you declare a cursor in a cobol-db2 program?
Are views updateable?
What is runstats utility in db2?
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 ?
What is the result of open cursor statement?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What does db2 mean?
How do I copy a table in db2?