Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why Cant we use group functions in where clause in SQL?

604684Oct 23 2007 — edited Oct 23 2007
Hi,

The following query gives an error:

select * from my_table where salary=MIN(salary);

"group function is not allowed here"

Why can't we use group functions in where clause in SQL?

Thanks..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 20 2007
Added on Oct 23 2007
5 comments
545 views