Simple question for SQL Student

From: "Johnny_5555" <dsiebert(at)u(dot)washington(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Simple question for SQL Student
Date: 2001-05-20 23:27:48
Message-ID: UpYN6.35853$p33.704674@news1.sttls1.wa.home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Blackin 2001-05-21 00:44:24 Re: sql question
Previous Message R Talbot 2001-05-20 21:53:30 Compiling for Caldera on 2nd Drive