On Fri, Jun 16, 2000 at 10:56:04AM +0200, Gerhard Dieringer wrote:
> > Yes this would work nicely but if I need to add more conditional clauses
> > I have to duplicate them in the main SELECT and in the sub-SELECT:
> >
> > SELECT title,stopdate
> > FROM auction
> > WHERE stopdate = (SELECT max(sto
Louis-David Mitterrand - [EMAIL PROTECTED] - http://www.apartia.fr wrote:
> ...
> Yes this would work nicely but if I need to add more conditional clauses
> I have to duplicate them in the main SELECT and in the sub-SELECT:
>
> SELECT title,max(stopdate)
> FROM auction
> WHERE stopdate = (SELECT
On Fri, Jun 16, 2000 at 09:28:27AM +0200, Gerhard Dieringer wrote:
> > I am trying to return the most recently updated record from a table:
> >
> > SELECT max(stopdate) FROM auction;
> >
> > and this works but only returns the timestamp, however if I try to get
> > another column with the aggregat
Louis-David Mitterrand - [EMAIL PROTECTED] - http://www.apartia.fr wrote:
> Hello,
>
> I am trying to return the most recently updated record from a table:
>
> SELECT max(stopdate) FROM auction;
>
> and this works but only returns the timestamp, however if I try to get
> another column with the
Hello,
I am trying to return the most recently updated record from a table:
SELECT max(stopdate) FROM auction;
and this works but only returns the timestamp, however if I try to get
another column with the aggregate it fails:
SELECT title,max(stopdate) FROM auction;
ERROR: Attribute auction.t
