Select avg(sal) from Emp where avg(sal) >1000; This gives an error.

which clause we are not used in where clause?

Question Posted / chandana

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

Please Help Members By Posting Answers For Below Questions

How to view the tablespaces in the current database?

552

What is the difference between alert log file and tarce file ?

1628

How to invoke the original export import utilities?

503

What is a sub query? What are its various types?

581

How to drop a stored procedure in oracle?

586

What is an oracle wallet?

506

Can a parameter be passed to a cursor?

597

can u plz provide me oca sql dumps please i need them

1461

what are the default admin accounts in Oracle 10g ?

503

When do you get a .pll extension in oracle?

672

Why do we use bulk collect in oracle?

567

How to load excel data sheet to oracle database

582

How do I uninstall oracle client from windows?

532

Respected sir, Please send me technical questions related to oracle apps..

1371

What are transaction isolation levels supported by oracle?

572