Re: Need SELECT tips

From: Marc <E.Mail_at_address.com>
Date: Fri, 28 Jan 2000 07:54:29 +0100
Message-ID: <86relf$dhh$1@vkhdsu24.hda.hydro.com>

A possible solution is :

SQL> l
  1 select min(col1) col1, col2
  2 from temp
  3* group by col2
SQL> / C COL2
- ----------

A          1
C          2
E          3

Marc

Violin wrote in message <3893f0c5.236359_at_172.16.7.5>...
>Hello,
>If I have a table : TEMP
>COL1 CHAR(1) primary key
>COL2 CHAR(1)
>
>col1 col2
>---------------
> A 1
> B 1
> C 2
> D 2
> E 3
> F 3
>
>How could I select the result?
>
>col1 col2
>---------------
> A 1
> C 2
> E 3
>
>Thank you for any tips.
>
>Violin.
>violin.hsiao_at_mail.pouchen.com.tw
Received on Fri Jan 28 2000 - 00:54:29 CST