what is difference between where clause and having clause?
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
What are the execution control statements in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is rowid and rownum in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is oracle sid?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What are dml statements in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How do you store pictures in a database?
Is truncate autocommit in oracle?
How to rename a tablespace in oracle?
Explain database link?
Write a syntax for update query in oracle?
Does oracle database need java?
Explain enable novalidate constraint.