What is the difference between Where and Having Clause
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
What is access path in db2?
What does db2 mean?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
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 the use of value function?
What is ibm db2 client?
What is the purpose of rollback and commit?
Why db2 is called db2?
How to fetch the last row from the table in SQL (db2)?
Define db2 and its databases?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Where do you specify them?
What is catalog database in db2?
Is db2 a mainframe database?
What is dbrm?