Re: SQL to retrieve all distinct records

  • From: Jocke Treugut <treugut_tuning@xxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 15 Apr 2004 15:54:49 +0200 (CEST)

Hi, Alison!

It looks like you want the smallest value for C (from
your example with SYS and SYS2). If that is correct

SELECT a, b, MIN( c ) FROM testing GROUP BY a, b;

should work.

Cheers / Jocke Treugut

Höstrusk och grå moln - köp en resa till solen på Yahoo! Resor på adressen
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: