Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36320 Views
- I also Faced
- E-Mail Answers
Answer Posted / mrityunjay kumar dubey
A WHERE Clause is used to restrict a row and HAVING Clause is used to restrict a group.WHERE Clause can be used for specifying the search criteria in SELECT, DELETE, UPDATE statements.HAVING Clause is used when GROUP BY Clause is used.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is using clause and give example?
How to write date and time literals in oracle?
What is a database table in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
What is the best way to do multi-row insert in oracle?
Explain the use of grant option in imp command.
How to drop an existing view in oracle?
What is a tns service name?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What do you mean by merge in oracle and how can you merge two tables?
How do I limit the number of rows returned by an oracle query after ordering?
How to load data through external tables?
Can select statements be used on views in oracle?
What are the common oracle dba tasks?
What is data file?
