Re: Problem with SQL!!

Simon Mercer wrote:

> column1 | column2
> 0 100
> 1 100
> 2 100
> 3 200
> 4 200
>
> - where column1 is the primary key.
>
> All I want to get is, for each value in column2, the lowest value
> in column1;
>
> 0 | 100
> 3 | 200

   select min(column1), column2 from table_t group by column2

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841