which clause we are not used in where clause?
Answer Posted / chandana
Select avg(sal) from Emp
where avg(sal) >1000;
This gives an error. So, Group Functions(Aggregate) should
not be used in the Where Clause
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain enable novalidate constraint.
What are the uses of Database Trigger ?
How to run the anonymous block again?
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?
Is there a function to split a string in plsql?
How to use "for" statements in oracle?
Why should I use oracle database?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What suggestions do you have to reduce the network traffic?
How to install oracle database 10g xe?
What is hot backup and logical backup?
Please explain compound trigger in oracle?
How to lock and unlock a user account in oracle?
How to set up autotrace for a user account?
What is the difference between post-database commit and post-form commit?