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
>