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 delete a user account in oracle?

1022

How to sort output in descending order in oracle?

1104

What are the tools for Oracle ?

1112

How to bring a tablespace online?

1145

How to create a temporary table in oracle?

1335

What is the use of aggregate functions in oracle?

1072

Can you tell me how to add new column in existing views?how?How is possible?

1515

What privilege is needed for a user to delete rows from tables in another schema?

1137

How many anonymous blocks can be defined?

1253

What is an Oracle index?

1703

How to define a cusotmer as a supplier in ORACLE R12

2305

material view and view disadvantages?

1127

What is a cursor and what are the steps need to be taken?

1290

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

2232

What is transaction control statement and how many types of transaction control statement in Oracle?

1236