Re: join problem or maybe group :(

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