Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36883 Views
- I also Faced
- E-Mail Answers
Answer Posted / suga priya
query:WHERE DEPARTMENT > 333
query:HAVING AVG(SALARY) > 50000.
| Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
Can we create database in oracle using command line ?
What is execute immediate in oracle?
What is a parameter file in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is clustered table in Oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Is there a function to split a string in plsql?
Can we commit inside a function in oracle?
How to run create database statement again?
Explain rename?
How to loop through a cursor variable?
How do I manually create a database in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to loop through data rows in the implicit cursor?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
