Need SELECT tips

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 Thu Jan 27 2000 - 23:18:33 CST