Why Cant we use group functions in where clause in SQL?
604684Oct 23 2007 — edited Oct 23 2007Hi,
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..