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(at)ikono(dot)com(dot)br
Ikono Sistemas e Automação
http://www.ikono.com.br