Re: DISTINCT ON ONE ROW

select min(id) "ID",name "Name"
from <table>
group by name
order by min(id);

Volker

Joerg Leute wrote:
>
> Suppose i have a table like this
>
> ID Name
> 1 Joe
> 2 Frank
> 3 Frank
> 4 Frank
> 5 Jack
>
> Is there any way (like distinct) to have a result like this
>
> ID Name
> 1 Joe
> 2 Frank
> 5 Jack
Received on Thu Jul 29 1999 - 10:26:30 CDT