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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
