What is the difference between Where and Having Clause
- 7 Answers
- 28641 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
If I have a view which is a join of two or more tables, can this view be updateable?
What does runstats do in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is db2 instance?
How to check last update on table in db2?
How do I change the column size in db2?
What are the benefits of using the db2 database?
What is rebind in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is table space in db2?
What is buffer pool in the db2 database?
Are view updateable?
What is null indicator in cobol db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
