Re: Simple question for SQL Student

On Monday 21 May 2001 01:27, Johnny_5555 wrote:
> I want to use an aggregate function in the WHERE clause and SQL Server 7
> won't let me?  Specifically, I need to find a customer ID where the budget
> is equal to MAX(budget).  Is my logic wrong?  How can I display the the
> customer ID with the biggest budget?  Any help is really appreciated.  TIA
>
>
>
select customerId,max(budget)
from <table_name>
group by customerId
having mx(budget)=xxx