what is difference between where clause and having clause?
Answer Posted / rajesh dutta
where conditions used only for comparing row values.
having conditions used to compares group values like
min,max,count etc.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Explain about your project and its relation to the current job position you are applying to?
Can a formula column be obtained through a select statement ?
How to use existing values in update statements using oracle?
How to turn on or off recycle bin for the instance?
What is bulk copy or bcp in oracle?
How to increment dates by 1 in oracle?
What is merge in oracle?
Differentiate between post-database commit and post-form commit?
How many types of auditing in Oracle?
What is an oracle recycle bin?
What privilege is needed for a user to create views in oracle?
Difference between open_form and call_form in oracle.
What is catalog in Oracle?
How to save query output to a local file?
Can group functions be mixed with non-group selection fields?