what is difference between where clause and having clause?
Answer Posted / manvendra
RISTRICT GROUP BY FUNCTION BY HAVING.
RESTRICT NORMAL QUERY BY WHERE.
YOU CAN PUT WHERE AND HAVING IN A QUERY.
| Is This Answer Correct ? | 14 Yes | 21 No |
Post New Answer View All Answers
What is the data pump import utility?
How to use an explicit cursor without open statements?
How does Oracle guarantee data integrity of data changes?
what is Single Byte Overhead...?
How to specify default values in insert statement using oracle?
How to get the Installed Oracle Version Information ?
What is oracle thin client?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What exactly do quotation marks around the table name do?
What is a private synonym?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to get execution path reports on query statements?
List out the difference between commit, rollback, and savepoint?
How do I connect to oracle database?
What are operators in oracle?