Thread: Simple question for SQL Student

Simple question for SQL Student

From
"Johnny_5555"
Date:
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





Re: Simple question for SQL Student

From
snpe
Date:
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