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

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2071

Compare and contrast between sql and sql server and explain its various functions?

915

What is the difference between count (*), count (expression), count (distinct expression)?

963

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2899

How to connect the oracle server as sysdba?

1008

Explain the use of full option in exp command.

1053

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1010

What are the tools for Oracle ?

1005

What is SQL access advisor in Oracle?

1134

How do I call oracle stored procedures that take no parameters?

1017

What is the difference between hot backup and cold backup in oracle?

952

What are the four Oracle system processes that must always be up and running for the database to be useable?

953

Why is oracle database so popular?

946

Explain the use of file option in exp command.

1078

Difference between pre-select and pre-query

1027