Home > mailing lists

Simple question for SQL Student - Mailing list pgsql-general

From	Johnny_5555
Subject	Simple question for SQL Student
Date	May 22, 2001 18:41:20
Msg-id	UpYN6.35853$p33.704674@news1.sttls1.wa.home.com Whole thread Raw
Responses	Re: Simple question for SQL Student (snpe <snpe@infosky.net>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: "Craig Orsinger"
Date: 22 May 2001, 18:41:18
Subject: NOTIFY/LISTEN Using Embedded SQL (ecpg)

From: "Iwan van der Kleyn"
Date: 22 May 2001, 18:47:45
Subject: initdb doesn't work with cygwin 1.3.1?

Simple question for SQL Student - Mailing list pgsql-general

Previous

Next