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

What is an oracle?

995

How can we find out the current date and time in oracle?

1079

How to use attributes of the implicit cursor in oracle?

985

definition of cluster and non-clustered index?

3011

Will you be able to store pictures in the database?

1093

What are the predefined tablespaces in a database?

1056

How can we view last record added to a table?

1021

How to list all tables in your schema?

1028

How to see free space of each tablespace?

1017

Is insert autocommit in oracle?

1055

What is materialized view in Oracle?

1060

What is the difference between sharding and replication?

1019

How do we create privileges in oracle?

1030

How to filter out duplications in the returning rows using oracle?

1006

What are the arithmetic operations?

1065