Thread

Re: join problem or maybe group :(

Henshall, Stuart - WCP <shenshall@westcountrypublications.co.uk> — 2002-08-30T13:21:18Z

There is a non-ansi way of doing it:
SELECT column1,column2 FROM table ORDER BY column1 DESC LIMIT 1;
- Stuart 

> -----Original Message-----
> From: Diogo Biazus [mailto:diogo@ikono.com.br]
> 
> 
> I think that a subselect will do that, but I'm not sure if it is the 
> best way.
> Try something like:
> 
> select max(column1), (select column2 from table where column1 
> = (select max(column1) from table)) from table;
> 
> 
> >Just wonder, how can i do:
> >
> >select max(column1), column2 from table;
> >
> >its saying:
> >ERROR:  Attribute table.column2 must be GROUPed or used in 
> an aggregate
> >function
> >
> >and all i want is that column2 value will be the mate fo column1 max?
> >
> >like if
> >clumn1     column2
> >1                 a
> >2                 b
> >3                 c
> >
> >it will return 3,c
> >
> 
> -- 
> Diogo de Oliveira Biazus
> diogo@ikono.com.br
> Ikono Sistemas e Automação
> http://www.ikono.com.br
> 
> 
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>