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